Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 77771 invoked from network); 14 Feb 2008 13:55:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 14 Feb 2008 13:55:06 -0000 Received: (qmail 31056 invoked by uid 500); 14 Feb 2008 13:55:00 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 31006 invoked by uid 500); 14 Feb 2008 13:55:00 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 30997 invoked by uid 99); 14 Feb 2008 13:55:00 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Feb 2008 05:55:00 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of jazarine4derby@gmail.com designates 209.85.132.245 as permitted sender) Received: from [209.85.132.245] (HELO an-out-0708.google.com) (209.85.132.245) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Feb 2008 13:54:28 +0000 Received: by an-out-0708.google.com with SMTP id c8so107255ana.45 for ; Thu, 14 Feb 2008 05:54:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; bh=ic6VO2pb/hXdcN6ad/iHFExAfrzSQj61cDu4z+1ah8c=; b=j2kYF56PdeK5hTaImdkM11IykOXZx3OiNr9sFbbl55PH+GQzco7wlHtQcfRgIEvBI0D12Yhj1kwNcw1BHdlC8aqa6KYd5WSVtKjPeV++bIbr10/v0b1Mq6thSgJKq7TNJjVBjI9flpLm4q05MdjGRMqOhiVDkvHoGY4DVTjjm6k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=MFjqdGKWd2zTRn3KPeH5lJs/B40PvVfsoASZWLvtoGWJgDLiX4Y29H/ranu+4U8u/YIKGTU2t7gl/uP/ELNssEvOc1Nsh9zttog8fNrsrxhR3DZhvfJxJrVEDBixBLoQdcR/iPsjWlwt6BN44VAgL4q6yxlmfQahpnWIROUBN2s= Received: by 10.101.66.14 with SMTP id t14mr1526584ank.5.1202997276132; Thu, 14 Feb 2008 05:54:36 -0800 (PST) Received: by 10.100.93.9 with HTTP; Thu, 14 Feb 2008 05:54:36 -0800 (PST) Message-ID: <6b47fb310802140554w1ea09d64y29f3faf4bf8d736e@mail.gmail.com> Date: Thu, 14 Feb 2008 19:24:36 +0530 From: "Jazarine Jamal" To: derby-dev@db.apache.org Subject: Re: SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY In-Reply-To: <47B44328.500@sun.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1531_13966241.1202997276124" References: <6b47fb310802131139s7e0816aaka2b3b5fc35977fb6@mail.gmail.com> <47B365A9.2050804@sun.com> <6b47fb310802132324k479c2ce8p86e48e43572d14bb@mail.gmail.com> <47B44328.500@sun.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_1531_13966241.1202997276124 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks Rick, That was helpful.. On Thu, Feb 14, 2008 at 7:03 PM, Rick Hillegas 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 > > > 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 > > > > > > ------=_Part_1531_13966241.1202997276124 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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
>
>


------=_Part_1531_13966241.1202997276124--