 |
» |
|
|
|
SYSTEM.PROCEDURE contains information about each procedure
created in the DBEnvironment. SYSTEM.PROCEDURE is initially empty, and it is updated whenever ALLBASE/SQL
processes a CREATE PROCEDURE, DROP PROCEDURE, or TRANSFER
OWNERSHIP statement on a procedure. If a TRANSFER OWNERSHIP is done on the procedure, the owner field
in this view is updated with the name of the new owner. Table 8-24 System.Procedure | Name | Type | Length | Description |
|---|
| NAME | CHAR | 20 | Name of the procedure | | OWNER | CHAR | 20 | Owner of the procedure | | NUMP | INTEGER | 4 | Number of parameters ( 0 to 1023) to the procedure | | NUMR | SMALLINT | 2 | Number of result columns ( 0 to 1024) for a procedure defined with a WITH RESULT clause | | MULTIRESULT | SMALLINT | 2 | Number of SELECT statements with no INTO clause in the procedure (0 if there are none) | | CTIME | CHAR | 16 | Time of creation: yyyymmddhhmmsstt | | LANGUAGEID | SMALLINT | 2 | Code for the language of this procedure. A complete list of language codes
appears in /usr/lib/nls/config | | DBEFILESET | CHAR | 20 | Name of the DBEFileSet containing the procedure's definition and stored sections |
EXAMPLE | |
select * from system.procedure;
--------------------+--------------------+-----------+------
NAME |OWNER |NUMP |NUMR
--------------------+--------------------+-----------+------
PROCESS12 |MANUFDB | 3| 2
DISCOUNTPART |PURCHDB | 1| 3
---------------------------------------------------------------------------
Number of rows selected is 2
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] >
select multiresult, ctime, languageid from system.procedure;
-----------+----------------+----------+--------------
MULTIRESULT|CTIME |LANGUAGEID|DBEFILESET
-----------+----------------+----------+--------------
3|1991121010220700| 0|SYSTEM
1|1991121011442200| 0|PURCHFS
---------------------------------------------------------------------------
Number of rows selected is 2
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] >
|
|
