 |
» |
|
|
|
SYSTEM.PARAMETER contains information about parameters that may be
passed to and from procedures.
SYSTEM.PARAMETER is
initially empty, and it is updated whenever ALLBASE/SQL
processes a CREATE PROCEDURE, DROP PROCEDURE, or
TRANSFER OWNERSHIP statement for a procedure that includes
parameters. 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-20 System.Parameter | Name | Type | Length | Description |
|---|
| NAME | CHAR | 20 | Name of the parameter | | PROCNAME | CHAR | 20 | Name of the procedure | | OWNER | CHAR | 20 | Owner of the procedure | | NUM | INTEGER | 4 | Number of the parameter within the procedure | | Length | INTEGER | 4 | - Either
Maximum length of the column if TYPECODE is 3 (VARCHAR), 9 (NATIVE VARCHAR), or 14 (VARBINARY) - Or
Number of bytes in the column for all other data types
| | TYPECODE | SMALLINT | 2 | Data type of the column: - 0
INTEGER or SMALLINT (set by the LENGTH field) - 1
BINARY - 2
CHAR (ASCII only) - 3
VARCHAR (ASCII only) - 4
FLOAT or REAL (set by the LENGTH field) - 5
DECIMAL - 6
TID - 7
reserved - 8
NATIVE CHAR - 9
NATIVE VARCHAR - 10
DATE - 11
TIME - 12
DATETIME - 13
INTERVAL - 14
VARBINARY
| | NULLS | SMALLINT | 2 | Null value indicator: - 0
if the column cannot contain null values - 1
if the 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) | | DEFAULTTYPE | SMALLINT | 2 | Default value type indicator: - 0
no default clause specified - 1
DEFAULT NULL - 2
DEFAULT USER - 3
DEFAULT Constant - 4
DEFAULT CURRENT_DATE - 5
DEFAULT CURRENT_TIME - 6
DEFAULT CURRENT_DATETIME
| | OUTPUT | SMALLINT | 2 | Parameter type: - 0
input - 1
input/output - 2
output only
|
EXAMPLE | |
select * from system.parameter;
--------------------+--------------------+--------------------+-----------
NAME |PROCNAME |OWNER |NUM
--------------------+--------------------+--------------------+-----------
OPERATOR |PROCESS12 |MANUFDB | 1
SHIFT |PROCESS12 |MANUFDB | 2
FAILURETYPE |PROCESS12 |MANUFDB | 3
PARTNUMBER |DISCOUNTPART |PURCHDB | 1
NAME |REPORTMONITOR |PURCHDB | 1
OWNER |REPORTMONITOR |PURCHDB | 2
TYPE |REPORTMONITOR |PURCHDB | 3
VENDORNUMBER |DELVENDOR |PURCHDB | 1
VENDORNUMBER |CHECKVENDOR |PURCHDB | 1
PARTNUMBER |PROCESS15 |PETERW | 1
PERCENTAGE |DISCOUNTALL |PURCHDB | 1
NROWS |ENTERTEST |PETERW | 1
---------------------------------------------------------------------------
Number of rows selected is 12
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] >
select length, typecode,nulls,precision from system.parameter;
-----------+--------+------+---------
LENGTH |TYPECODE|NULLS |PRECISION
-----------+--------+------+---------
20| 2| 0| 0
20| 2| 0| 0
10| 2| 0| 0
16| 2| 1| 0
20| 2| 0| 0
20| 2| 0| 0
10| 2| 0| 0
4| 0| 0| 10
4| 0| 0| 10
16| 2| 0| 0
4| 5| 1| 4
4| 0| 1| 10
---------------------------------------------------------------------------
Number of rows selected is 12
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] >
select scale, languageid, defaulttype, output from system.parameter;
------+----------+-----------+------
SCALE |LANGUAGEID|DEFAULTTYPE|OUTPUT
------+----------+-----------+------
0| 0| 0| 0
0| 0| 0| 0
0| 0| 0| 0
0| 0| 0| 0
0| 0| 0| 0
0| 0| 0| 0
0| 0| 0| 0
0| 0| 0| 0
0| 0| 0| 0
0| 0| 0| 0
2| 0| 0| 0
0| 0| 0| 0
---------------------------------------------------------------------------
Number of rows selected is 12
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] >
|
|
