Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 7054 invoked from network); 20 Aug 2009 06:58:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 20 Aug 2009 06:58:40 -0000 Received: (qmail 27322 invoked by uid 500); 20 Aug 2009 06:58:59 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 27308 invoked by uid 500); 20 Aug 2009 06:58:59 -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 27300 invoked by uid 99); 20 Aug 2009 06:58:58 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Aug 2009 06:58:58 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of shazin.sadakath@gmail.com designates 209.85.216.193 as permitted sender) Received: from [209.85.216.193] (HELO mail-px0-f193.google.com) (209.85.216.193) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Aug 2009 06:58:50 +0000 Received: by pxi31 with SMTP id 31so238167pxi.24 for ; Wed, 19 Aug 2009 23:58:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=uF0N2qtfEPG3RuE7DCcB4KsXvpybSLLvDPLI0Sl6ibI=; b=WZuvT+Fhcx9r7G7J/cyyHeuH2U1sK286MvX6Rd/jSp5nNDBGW1QS0FWWMx84DFkaTd ++1b+/hzGYxuuf1wf0p80JleXQcusJLC73ivCDs8Un3IXu/9l8isbAoHS1YJl76co4hn hSGNf66GP44Vq6cshtu/WtSSvJLaCwuXOt2Aw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=XENfadjyow+47ICsf6hui+YkboZUXqfd/u5dywYfWFIdhEGhJNZahnfRAP4LuBJOen P1AG/+XYygOaFXvWLOfjE4iyBssBrvdpOWRCgsFOfT63fPmqwSmC+mP/yCiPgfmyIwh2 Xb9Ha9eguIbJLLbr8kz/V0gLyFCETC0sJrL3U= MIME-Version: 1.0 Received: by 10.114.4.24 with SMTP id 24mr8906292wad.128.1250751510528; Wed, 19 Aug 2009 23:58:30 -0700 (PDT) In-Reply-To: <4A8BF411.202@sun.com> References: <22b99aa10908190512w6b786b21s6449d87a5c2d3073@mail.gmail.com> <4A8BF411.202@sun.com> Date: Thu, 20 Aug 2009 12:28:30 +0530 Message-ID: <22b99aa10908192358n5f6b953v84faeef86d9c666b@mail.gmail.com> Subject: Re: Stored Procedures & Functions From: Shazin Sadakath To: derby-dev@db.apache.org Content-Type: multipart/alternative; boundary=0016e649c17c7cc1ba04718d4787 X-Virus-Checked: Checked by ClamAV on apache.org --0016e649c17c7cc1ba04718d4787 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Thanks, Rick it helped alot. I have some more question regarding Stored procedures and Functions. Where can I find the DataTypes used in Stored Procedures and Functions? And How can get I get the database schema UUID ?? Thanks, Shazin On Wed, Aug 19, 2009 at 6:16 PM, Rick Hillegas wrote: > Hi Shazin, > > The code for the system procedures and functions lives in > org.apache.derby.catalog.SystemProcedures. These procedures and functions > are declared to the compiler by > org.apache.derby.impl.sql.catalog.DataDictionaryImpl. Just search those two > source files for the routine name you're interested in and you should be > able to make some headway. > > Hope this helps, > -Rick > > > Shazin Sadakath wrote: > >> Hi All, >> >> I would like to work on the Stored Procedures and Functions of SYSCS_UTIL >> Schema. >> Can anyone give me a pointer on where to look. >> I am relative new to Derby >> >> Thanks, >> Shazin >> > > --0016e649c17c7cc1ba04718d4787 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Thanks, Rick it helped alot.

I have some more question r= egarding Stored procedures and Functions.=A0
Where can I find the= DataTypes used in Stored Procedures and Functions?

And How can get I get the database schema UUID ??

= Thanks,
Shazin

On Wed, Aug 19, = 2009 at 6:16 PM, Rick Hillegas <Richard.Hillegas@sun.com> wrote:
Hi Shazin,

The code for the system procedures and functions lives in org.apache.derby.= catalog.SystemProcedures. These procedures and functions are declared to th= e compiler by org.apache.derby.impl.sql.catalog.DataDictionaryImpl. Just se= arch those two source files for the routine name you're interested in a= nd you should be able to make some headway.

Hope this helps,
-Rick


Shazin Sadakath wrote:
Hi All,

I would like to work on the Stored Procedures and Functions of SYSCS_UTIL S= chema.
Can anyone give me a pointer on where to look.
I am relative new to Derby

Thanks,
Shazin


--0016e649c17c7cc1ba04718d4787--