Re: SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY

[Rick Hillegas]

Hi Jazarine,

I don't see any references to that function in the tools code.

Regards,
-Rick

Jazarine Jamal wrote:

Thanks for that one Rick.

But I was actually asking if any tools like ij run this function implicitly for any reason such as authenticating a user etc. I want to make sure that this function is called only when a VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('');

is issued by the end user.
Is it like that.?

On Thu, Feb 14, 2008 at 3:18 AM, Rick Hillegas <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:

    Jazarine Jamal wrote:
    > Hi ....
    >
    > I would like to know if
    > SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY in SystemProcedures.java is
    > used only only when issuing a VALUES
    > SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY() function call?
    > If not, when is it otherwise executed? Just give one eg. if
    possible.
    >
    > I am working on a bug and the answer to this query will be very
    helpfull.
    >
    > Thanks..
    Hi Jazarine,

    I don't know if this is what you are looking for, but here is an
    example
    of invoking get_database_property in a query:

    create function intToString
    (
       intVal int
    )
    returns varchar( 10 )
    language java
    parameter style java
    no sql
    external name 'java.lang.Integer.toString'
    ;

    select t2.*
       from
           sys.systables systabs,
           table (syscs_diag.space_table(systabs.tablename)) as t2
       where systabs.tabletype = 'T'
       and intToString( t2.pagesize
    )=syscs_util.syscs_get_database_property( 'derby.storage.pageSize' )
    ;

    Hope this helps,
    -Rick