Thanks Rick,
That was helpful..
On Thu, Feb 14, 2008 at 7:03 PM, Rick Hillegas <[EMAIL PROTECTED]>
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
> > <[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
> >
> >
>
>
