 |
» |
|
|
|
The SYSTEM.PROCEDUREDEF view displays information about procedure
definitions, including the text of the procedure itself.
The procedure text is stored in a series of segments of up to 64 bytes,
starting with the initial BEGIN and ending with the final semicolon.
The procedure definition does not include parameter definitions,
which are stored separately in SYSTEM.PARAMETER. SYSTEM.PROCEDUREDEF is initially empty, and it is updated whenever ALLBASE/SQL
processes a CREATE PROCEDURE statement, a DROP PROCEDURE
statement, or a TRANSFER OWNERSHIP statement on a procedure. When the procedure is dropped, the rows making up the byte string of the procedure definition
are deleted. If a TRANSFER OWNERSHIP is done on the procedure,
the owner field in this table is updated with the Name of the new owner.
Table 8-26 System.ProcedureDef |
Column Name
|
Type
|
Length
|
Description |
|---|
|
NAME
|
CHAR
|
20
|
Name of the procedure | |
OWNER
|
CHAR
|
20
|
Owner of the procedure | | QUALIFIER | CHAR | 20 | Owner NAME to be used
to qualify any unqualified objects referenced in the
procedure definition | | SEGNUM | INTEGER | 4 | Segment number | | SEGLEN | INTEGER | 4 | Length of segment in bytes (up to 64)
| | DEFINESTRING | CHAR | 64 | Procedure definition byte string segment
|
Example | |
select * FROM System.ProcedureDef WHERE NAME = 'REPORTMONITOR';
--------------------+--------------------+--------------------+------
NAME |OWNER |QUALIFIER |SEGNUM
--------------------+--------------------+--------------------+------
REPORTMONITOR |PURCHDB |PURCHDB | 1
REPORTMONITOR |PURCHDB |PURCHDB | 2
---------------------------------------------------------------------------
First 2 rows have been selected.
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> r
+------+---------------------------------------------------------------
|SEGLEN|DEFINESTRING
+------+---------------------------------------------------------------
| 55| begin insert into PurchDB.ReportMonitor values (:Type,
| 45| CURRENT_DATETIME, USER, :NAME, :Owner); end;
---------------------------------------------------------------------------
First 2 rows have been selected.
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> r
|
|
