ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-62
PROCEDURE Statements
parameter-name
specifies the parameter name; parameter-name is an alphanumeric string up
to 60 characters in length that must begin with an alphabetic character,
followed by alphabetic, numeric, and underscore characters.
parameter-type
specifies the parameter data type as follows:
sql-data-type [ NULLABLE ] [ DEFAULT default-value ]
sql-data-type
is one of the following data types:
CHAR[ACTER] [ (length) ]
VARCHAR [ (length) ]
SMALLINT [ SIGNED | UNSIGNED ]
INT [ SIGNED | UNSIGNED ]
LARGEINT
NUMERIC [ ( precision [, scale ] ) ] [ SIGNED ]
[ UNSIGNED ]
FLOAT [ (precision) ]
REAL
DOUBLE PRECISION
DECIMAL ( precision [, scale ] ) [ SIGNED ]
[ UNSIGNED ]
DATETIME [ start-date-time TO ] end-date-time
DATE
TIME
TIMESTAMP [(seconds-precision)]
The precision value is either the length in bytes or the total number of
significant digits for numeric data types. The scale value defaults to zero
if it is omitted for a data type that requires scale.
The values for length, precision, and scale depend on the particular
SQL data type. See the NonStop SQL/MP Reference Manual for
descriptions of the various data types.
The PROCEDURE statements follow these restrictions:
Data Type Parameters Value Range Restrictions
CHAR length 1 < length < 4061
VARCHAR length 1 < length < 4059
SMALLINT precision = 5
INT precision = 10
LARGEINT precision=19
FLOAT precision
scale
0 < precision <= 54
0 <= scale <= precision