RE: Display SQL Function

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

If you want to know list of IBM DB2 built-ins, this link will help:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmstch2f
unc.htm

If on the other hand you want to use UDF (User Defined Functions) that you
and others have created on your system, you can see them in a couple of
ways:

- iNav's Functions folder under Databases->Schemas-><your
library>->Functions
- simply query the SQL UDF catalogue, i.e.
  SELECT * FROM SYSFUNCS

HTH, Elvis

Celebrating 10-Years of SQL Performance Excellence on IBM i5/OS and OS/400
www.centerfieldtechnology.com
 

-----Original Message-----
Subject: Display SQL Function

How can I display a function, or at least identify if a function
exists? Thanks...