Re: tbname information for CREATE FUNCTION
December 17, 2001 08:07 AM
(in response to Jerry Doong)
I could be wrong but my thought is...
Sysibm.sysroutines - describes user-defined functions (and
procedures) and in that table it will show the EXTERNAL-NAME of
routine (plan) that points to the tables used thus the table info
all other table info (Systables & Systablepart).
Disclaimer: All thoughts are mine and not of my company
<[login to unmask email] To: [login to unmask email]
Subject: tbname information for CREATE FUNCTION
Sent by: DB2
<[login to unmask email]>
to DB2 Data Base
I would like to know which db2 catalog table is used to store the
when I use the
CREATE FUNCTION ...
TABLE LIKE tbname AS LOCATOR