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
