C. Standard Catalog Interface : Catalogs : The iiprocedures Catalog
 
Share this page                  
The iiprocedures Catalog
The iiprocedures catalog contains one or more entries for each procedure defined. Because the procedure definition can contain more than 240 characters, iiprocedures can contain more than one row for a single procedure. The text may contain newlines and may be broken mid-word across rows. The text segment contains the procedure registration text, not the actual procedure definition text.
This table is keyed on procedure_name and procedure_owner:
Column Name
Data Type
Description
procedure_name
char(256)
The table or procedure name. Must be a valid name.
procedure_owner
char(32)
The owner of the table or procedure. Must be a valid name.
create_date
char(25)
The permit’s creation date. This is a date field.
proc_subtype
varchar(1)
The type of procedure, which is one of the following values:
N (native) = the database supports standard Ingres database procedures
I (import) = for Enterprise Access products, the database supports host DBMS procedures
E (external) = for Enterprise Access products, the database supports procedures external to the database
L (link) = a Ingres Star registered procedure
text_sequence
integer
The sequence number for the text, numbered from 1.
text-segment
varchar (240)
The text of the procedure definition.