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 07:24:25 GMT
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>
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