ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-63
PROCEDURE Statements
All of the preceding data types can be NULLABLE. Only SMALLINT, INT,
NUMERIC, and DECIMAL can be either SIGNED or UNSIGNED (the
default is SIGNED); LARGEINT can be SIGNED only.
default-value
is one of the following:
literal
date-time-literal
SYSTEM
CURRENT
NULL
The values for default-value depend on the particular SQL data type
involved; for example, date-time-literal and CURRENT are valid for
types DATETIME, DATE, TIME, and TIMESTAMP only. See the NonStop
SQL/MP Reference Manual for detailed descriptions of appropriate values
for these various data types.
parameter-designation
specifies either INPUT or INPUT/OUTPUT. INPUT specifies that the parameter
is passed as input to the stored procedure; INPUT/OUTPUT specifies that the
parameter is passed as input and is also returned by the procedure.
INPUT/OUTPUT is the default.
Considerations – ADD PROCEDURE_COLUMNS
The ADD PROCEDURE_COLUMNS statement:
•
Adds one entry in the ZNUPCOL table for each parameter specified
If an error occurs, the actions of ADD PROCEDURE_COLUMNS are rolled back.
REAL precision = 22
DOUBLE PRECISION precision = 54
NUMERIC precision
scale
0 < precision <= 18
0 <= scale < precision
DECIMAL precision
scale
0 < precision <= 18
0 <= scale < precision
DATE Format: YEAR to DAY
Julian restrictions
TIME Format: HOURS to SECOND
TIMESTAMP Fractional
seconds
6 digits microseconds
Data Type Parameters Value Range Restrictions