SYSROUTINES_SRC catalog table (deprecated)
The SYSROUTINES_SRC table contains source for generated routines, such as those created by Db2 for z/OS® Procedure Processor DSNTPSMP. The schema is SYSIBM.
Deprecated function: External SQL procedures are deprecated and not as fully supported as native SQL procedures. For best results, create native SQL procedures instead. For more information, see Creating native SQL procedures and Migrating an external SQL procedure to a native SQL procedure.
Rows in this table can be inserted, updated, and deleted.
Column name | Data type | Description | Use |
---|---|---|---|
SCHEMA | VARCHAR(128)
NOT NULL |
Schema of the routine. | G |
ROUTINENAME | VARCHAR(128)
NOT NULL |
Name of the routine. | G |
BUILDDATE | DATE
NOT NULL WITH DEFAULT |
Date the routine was built. | G |
BUILDTIME | TIME
NOT NULL WITH DEFAULT |
Time the routine was built. | G |
BUILDSTATUS | CHAR(1)
NOT NULL WITH DEFAULT 'C' |
Whether this version of the routine's source is the current version. | G |
SEQNO | INTEGER
NOT NULL |
Number of the source statement piece in CREATESTMT. | G |
IBMREQD | CHAR(1)
NOT NULL WITH DEFAULT 'N' |
A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators. The value in this field is not a reliable indicator of release dependencies. |
G |
CREATESTMT | VARCHAR(7500)
NOT NULL |
Routine source statement. | G |