How can i see my self defined functions?

[Sebastian Pfaff <se...@gmail.com>]

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

Re: How can i see my self defined functions?

[Sebastian Pfaff <se...@gmail.com>]

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 <Ri...@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
>>
>
>

Re: How can i see my self defined functions?

[Rick Hillegas <Ri...@Sun.COM>]

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
>