Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Stored Procedures

Stored Procedure System Tables

Scroll Prev Top Next More

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