11. OpenSQL Standard Catalogs : Standard Catalog Interface : The iiprocedures Catalog
 
Share this page                  
The iiprocedures Catalog
The iiprocedures catalog contains one or more entries for each database procedure defined on a database. Because the text of the procedure definition can contain more than 240 characters, iiprocedures may contain more than one entry for a single procedure. The text may contain newlines and may be broken mid-word across rows.
This table is keyed on procedure_name and procedure_owner:
Column Name
Data Type
Description
procedure_name
char(256)
The database procedure name, as specified in the create procedure statement.
procedure_owner
char(32)
The procedure owner's Ingres username.
create_date
char(25)
The procedure's creation date.
proc_subtype
char(8)
The subtype of this procedure. For standard Ingres procedures, this will be N (native). For Ingres Star, this may be I (imported).
text_sequence
smallint
The sequence number for the test_segment.
text_segment
varchar(240)
The text of the procedure definition.
system_use
char(8)
Contains S if the procedure is system-generated, U if created by a user, or blank if unknown. Ingres generates procedures to enforce table constraints.
security_label
char(8)
An empty string.
This column is deprecated.
row_proc
char(1)
Contains Y if the procedure is row producing, N if not.