db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Derby Introspection - Is there a way to browse derby functions
Date Mon, 20 Jul 2009 15:27:34 GMT
Amir Bar-Or wrote:
> Does Derby stores "create functions" is some system catalog that the user is
> able to browse?  Get the function type , the operands etc?
>
> If so,  is something like this also available for builit-in functions?
>
> Regards,
> Amir
>   
Hi Amir,

As Lily pointed out, you can get the information you need from the 
system catalog SYSALIASES. However, to tease out a lot of the 
information you need, you may have to unpack the object in 
SYSALIASES.ALIASINFO.

You can probably get the information you need from the JDBC metadata. 
That would be the clean, supported way to gather this information. The 
following useful methods were introduced in Java 6:

DatabaseMetaData.getFunctions()
DatabaseMetaData.getFunctionColumns()

These methods will give you the metadata for both system and 
user-created functions.

Hope this helps,
-Rick

Mime
View raw message