 |
» |
|
|
|
SYSTEM.PROCRESULT contains information about the result columns in
procedure result sets for procedures returning results of a single
format. Such procedures are created using the WITH RESULT clause. SYSTEM.PROCRESULT is initially empty, and is updated whenever ALLBASE/SQL
processes a CREATE PROCEDURE statement including the WITH RESULT clause,
or a DROP PROCEDURE or TRANSFER OWNERSHIP statement specifying such
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-26 System.ProcResult | Name | Type | Length | Description |
|---|
| PROCEDURE | CHAR | 20 | Name of the procedure | | OWNER | CHAR | 20 | Owner of the procedure | | RESULTNUM | INTEGER | 4 | Number of the procedure result column | | Length | INTEGER | 4 | Maximum length of the result column if TYPECODE is 3 (VARCHAR), 9 (NATIVE VARCHAR),
or 14 (VARBINARY) or number of bytes in the result column for all other data types | | TYPECODE | SMALLINT | 2 | Data type of the result column: - 0
for INTEGER or SMALLINT (these two are distinguished by the LENGTH field) - 1
for BINARY - 2
for CHAR (ASCII only) - 3
for VARCHAR (ASCII only) - 4
for FLOAT or REAL (these two are distinguished by the LENGTH field) - 5
for DECIMAL - 6
for TID (for ALLBASE/SQL use only) - 7
reserved - 8
for NATIVE CHAR - 9
for NATIVE VARCHAR - 10
for DATE - 11
for TIME - 12
for DATETIME - 13
for INTERVAL - 14
for VARBINARY - 15
for LONG BINARY - 16
for LONG VARBINARY
| | NULLS | SMALLINT | 2 | Nullability: - 0
if the result column cannot
contain null values - 1
if the result column can contain
null values
| | PRECISION | SMALLINT | 2 | Number of significant decimal or binary digits
in the number (excluding the sign and the decimal point) | | SCALE | SMALLINT | 2 | Number of digits after the decimal point | | LANGUAGEID | SMALLINT | 2 | Code for the language of this column.
A complete list of language codes appears in /usr/lib/nls/config.
A value of -1 means not applicable (for non-character type columns) |
EXAMPLE | |
select procedure, owner, resultnum, length from system.procresult;
--------------------+--------------------+-----------+-----------
PROCEDURE |OWNER |RESULTNUM |LENGTH
--------------------+--------------------+-----------+-----------
PROCESS12 |MANUFDB | 1| 30
PROCESS12 |MANUFDB | 2| 20
---------------------------------------------------------------------------
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 typecode, nulls, precision, scale, languageid from system.procresult;
--------+------+---------+------+----------
TYPECODE|NULLS |PRECISION|SCALE |LANGUAGEID
--------+------+---------+------+----------
0| 0 5| 0| -1
2| 1| 0| 0| 0
---------------------------------------------------------------------------
Number of rows selected is 2
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] >
|
|
