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 ;