 |
» |
|
|
|
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-25 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.
Run NLUTIL.PUB.SYS to display a complete list of native
languages and codes for your system.
| 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] >
|
|