A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iiprocedures Catalog
 
Share this page                  
iiprocedures Catalog
The iiprocedures catalog contains one or more entries for each database procedure defined on a database.
Column Name
Data Type
Description
procedure_name
char(256)
The name of the procedure
procedure_owner
char(32)
The owner of the procedure
create_date
char(25)
The creation date of the procedure
proc_subtype
varchar(1)
N if native
text_sequence
integer
The sequence number from 1 for the test_segment
text_segment
varchar(240)
The text of the procedure definition
system_use
char(1)
U if the object is a user object
G if generated by the system for the user
security_label
char(8)
An empty string
This column is deprecated.
row_proc
char(1)
Y if the procedure is row producing
N if the procedure is not row producing