db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sebastian Pfaff" <sebastian.pf...@gmail.com>
Subject Re: How can i see my self defined functions?
Date Fri, 01 Aug 2008 13:49:35 GMT
Hello Rick,

tnx for your fast reply. Your select stmt works fine.

Regards

Sebastain

On Fri, Aug 1, 2008 at 3:41 PM, Rick Hillegas <Richard.Hillegas@sun.com> wrote:
> Hi Sebastian,
>
> I don't know why the ij SHOW command displays procedures but not functions.
> I have created a new JIRA (DERBY-3809) for adding SHOW FUNCTIONS. I think
> this is a straightforward project so I have marked it as appropriate for
> newcomers.
>
> In the meantime, you can get the information you need by invoking
> DatabaseMetaData.getFunctions(). That method was added in Java 6. From ij,
> you may be able to get the information you need by querying the system
> catalogs:
>
> select s.schemaname, a.alias, a.javaclassname
> from sys.sysschemas s, sys.sysaliases a
> where a.schemaid = s.schemaid
> and a.aliastype = 'F'
>
> Hope this helps,
> -Rick
>
> Sebastian Pfaff wrote:
>>
>> hi @ll,
>>
>> how can i see my self defined functions within the database? What i
>> mean, is something like this for procedures: ij> SHOW PROCEDURES;
>>
>> AFAIK, this information is elsewhere stored in one of the derby system
>> tables, but i can't remember where.
>>
>> TNX in advance
>>
>> Sebastian
>>
>
>

Mime
View raw message