 |
» |
|
|
|
SYSTEM.PARAMDEFAULT contains information about the default values of
parameters that may be passed to and from procedures. SYSTEM.PARAMDEFAULT 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 default parameter values. If a TRANSFER OWNERSHIP is done on the procedure, the owner field
in this view is updated with the Name of the new owner. For literal default values, the source string
containing the default value specification is stored in
segments of up to 64 bytes.
Only BINARY or CHARACTER string columns may require more than one 64 byte
segment. All other data types can fit in a 64 byte field. Table 8-20 System.Paramdefault | Column Name | Type | Length | Description |
|---|
| NAME | CHAR | 20 | Name of the parameter with a default | | PROCNAME | CHAR | 20 | Name of the procedure containing this
parameter | | OWNER | CHAR | 20 | Owner of the procedure | | SEGNUM | SMALLINT | 2 | Segment number | | SEGLEN | SMALLINT | 2 | Length of segment in bytes | | DEFAULTVAL | CHAR | 64 | Literal value string segment
|
Example | |
SELECT Name, ProcName, Owner FROM System.Paramdefault;
------------+--------------------+--------------------
NAME |PROCNAME |OWNER
------------+--------------------+--------------------
SHIFTNAME |PROCESS12 |PURCHDB
------------------------------------------------------
Number of rows selected is 1
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
SELECT SegNum, SegLen, DefaultVal FROM System.Paramdefault;
------+------+--------------------------------------------------------------
SEGNUM|SEGLEN|DEFAULTVAL
------+------+--------------------------------------------------------------
1| 3|Day
----------------------------------------------------------------------------
Number of rows selected is 1
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
|
