The R:BASE system tables are created by R:BASE when a database is created. They contain system information. The following are new system tables. Stored procedures are stored in the database in the system table called SYS_PROCEDURES. Supporting system tables are SYS_PROC_COLS and SYS_PROC_MODS.
Table: sys_PROCEDURES
Column Name |
Data Type |
Description |
sys_proc_id |
INTEGER |
Procedure identification |
sys_proc_name |
NOTE |
Procedure name |
sys_proc_locked_by |
NOTE |
Last user to do a PUT or LOCK |
sys_proc_comment |
NOTE |
Descriptive comment for procedure |
sys_proc_src |
LONG VARCHAR |
Procedure source |
sys_proc_mod_ts |
DATETIME |
Timestamp of procedure |
sys_proc_obj |
LONG VARBIT |
Reserved for future use |
sys_proc_usage |
INTEGER |
Reserved for future use |
sys_proc_flags |
INTEGER |
Internal binary flags. Bit 0 is the LOCK flag. |
sys_proc_version |
INTEGER |
Version number of procedure |
Table: sys_proc_cols
Column Name |
Data Type |
Description |
sys_proc_col_id |
INTEGER |
Argument identification |
sys_proc_id |
INTEGER |
Procedure identification |
sys_proc_col_name |
NOTE |
Name of argument |
sys_proc_iotype |
INTEGER |
Argument type values equal to: SQL_RETURN_VALUE (5) SQL_PARAM_OUTPUT (4) SQL_PARM_INPUT (1) SQL_PARAM_INPUT_OUTPUT (2) Currently only INPUT and RETURN types are supported. |
sys_proc_datatype |
INTEGER |
Data type of argument |
sys_proc_len |
INTEGER |
Argument data length |
sys_proc_scale |
INTEGER |
Argument data scale |
sys_proc_flags |
INTEGER |
Internal binary flags |
sys_proc_comment |
NOTE |
Descriptive comment for argument |
sys_proc_defvalu |
NOTE |
Reserved for future use |
Table: sys_proc_mods
Column Name |
Data Type |
Description |
sys_proc_mod_id |
INTEGER |
Archive identification |
sys_proc_id |
INTEGER |
Procedure identification |
sys_proc_mod_ts |
DATETIME |
Timestamp of archived procedure |
sys_proc_user |
NOTE |
User who did a PUT on procedure |
sys_proc_comment |
NOTE |
Descriptive comment for procedure |
sys_proc_fc |
LONG VARCHAR |
Reserved for future use |
sys_proc_delta |
LONG VARBIT |
Reserved for future use |
sys_proc_version |
INTEGER |
Version of archive |
Table: sys_TRIGGERS
Column Name |
Data Type |
Description |
sys_table_id |
INTEGER |
Table identification |
sys_trig_ins |
INTEGER |
Id of INSERT procedure |
sys_trig_upd |
INTEGER |
Id of UPDATE procedure |
sys_trig_del |
INTEGER |
Id of DELETE procedure |
