db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jazarine Jamal" <jazarine4de...@gmail.com>
Subject Re: SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY
Date Thu, 14 Feb 2008 13:54:36 GMT
Thanks Rick,
That was helpful..

On Thu, Feb 14, 2008 at 7:03 PM, Rick Hillegas <Richard.Hillegas@sun.com>
wrote:

> 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