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. |