PROCEDURES System Table Description

Description

Lists information about SQL or Java stored procedures.

Fields

Field Type Description
SCHEMA string The schema in which the procedure was created.
PROCEDURENAME string The name of the procedure.
CREATOR string The user who created the procedure.
PROCEDURETYPE integer Indicates the language of the procedure, defined as: 0=SQL, 1=Java
PROCEDURETEXT string The actual text of the procedure as entered at the time of CREATE PROCEDURE.
VERSION integer Internal version number reserved for future use.

Indexes

Primary Index: PROCEDURES..PRIMARY_KEY on fields: SCHEMA, PROCEDURENAME

Example

The following example shows the contents of SYSTEM.PROCEDURES after creating a simple procedure based on SQL QuickStart (See Running the SQL QuickStart). We use SET OUTPUT VERTICAL to make the display more readable.

SET OUTPUT VERTICAL;
SELECT * FROM system.procedures;
==================================== Row #1 ====================================
SCHEMA: USER
PROCEDURENAME: PRC_PLAYER_INFO
CREATOR: DBA
PROCEDURETYPE: 0
PROCEDURETEXT: (IN inPlayer INTEGER) AS VAR outParm STRING; IF (inPlayer > 99) 
THROW 'Player Numbers are 0 to 99'; END_IF; outParm = (SELECT name||' plays 
position '||position FROM hockey.hockey WHERE number = inPlayer); THROW outParm; 
END_PROCEDURE ;