db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY
Date Thu, 14 Feb 2008 13:33:28 GMT
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 
> <Richard.Hillegas@sun.com <mailto:Richard.Hillegas@sun.com>> 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
>
>


Mime
View raw message