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 <[EMAIL PROTECTED]> 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 >> > >
