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]> 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 >
