tbname information for CREATE FUNCTION

Jerry Doong

tbname information for CREATE FUNCTION
I would like to know which db2 catalog table is used to store the tbname
information
when I use the

CREATE FUNCTION ...
TABLE LIKE tbname AS LOCATOR


Thanks



[login to unmask email]

Re: tbname information for CREATE FUNCTION
(in response to Jerry Doong)
I could be wrong but my thought is...
Sysibm.sysroutines - describes user-defined functions (and stored
procedures) and in that table it will show the EXTERNAL-NAME of the
routine (plan) that points to the tables used thus the table info is where
all other table info (Systables & Systablepart).

hth

Shan



Disclaimer: All thoughts are mine and not of my company







Jerry Doong
<[login to unmask email] To: [login to unmask email]
.HONDA.COM> cc:
Subject: tbname information for CREATE FUNCTION
Sent by: DB2
Data Base
Discussion List
<[login to unmask email]>


12/14/2001 10:43
AM
Please respond
to DB2 Data Base
Discussion List









I would like to know which db2 catalog table is used to store the tbname
information
when I use the

CREATE FUNCTION ...
TABLE LIKE tbname AS LOCATOR


Thanks