PARAMETERS

Information on parameters of routines (procedures and UDFs) for which the current authorization identifier has privileges.

Column name

Data type

Contents

SPECIFIC_CATALOG

CHAR(18)

Database name

SPECIFIC_SCHEMA

CHAR(31)

Name of the schema to which the
routine belongs

SPECIFIC_NAME

CHAR(31)

Specific name of the routine

ORDINAL_POSITION

SMALLINT

Sequence number of the parameter in
the routine

PARAMETER_MODE

VARCHAR(5)

IN	input parameter
OUT	output parameter
INOUT	input and output parameter

IS_RESULT

VARCHAR(3)

NO irrelevant for SESAM/SQL

AS_LOCATOR

VARCHAR(3)

NO irrelevant for SESAM/SQL

PARAMETER_NAME

CHAR(31)

Name of the parameter

DATA_TYPE

VARCHAR(24)

Data type of the parameter
CHARACTER
CHARACTER VARYING
NATIONAL CHAR
NATIONAL CHAR VARYING
REAL
DOUBLE PRECISION
FLOAT
INTEGER
SMALLINT
NUMERIC
DECIMAL
DATE
TIME
TIMESTAMP

CHARACTER_
MAXIMUM_LENGTH

SMALLINT

Max. length of the parameter in code
units

if data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR or NATIONAL
CHAR VARYING

NULL value in all other cases

CHARACTER_OCTET_
LENGTH

SMALLINT

Max. length of the parameter in bytes

if data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR or NATIONAL
CHAR VARYING

NULL value in all other cases

CHARACTER_SET_
CATALOG

CHAR(18)

Database name

if data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR or NATIONAL
CHAR VARYING

NULL value in all other cases

CHARACTER_SET_
SCHEMA

CHAR(31)

INFORMATION_SCHEMA

if data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR or NATIONAL
CHAR VARYING

NULL value in all other cases

CHARACTER_SET_
NAME

CHAR(18)

EBCDIC

if data type is CHARACTER or
CHARACTER VARYING

UTF16

if data type is NATIONAL CHAR or
NATIONAL CHAR VARYING

NULL value in all other cases

COLLATION_CATALOG

CHAR(18)

Database name

if data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR or NATIONAL
CHAR VARYING

NULL value in all other cases

COLLATION_SCHEMA

CHAR(31)

INFORMATION_SCHEMA

if data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR or NATIONAL
CHAR VARYING

NULL value in all other cases

COLLATION_NAME

CHAR(18)

EBCDIC_BINARY,

if data type is CHARACTER or
CHARACTER VARYING

UTF16_BINARY,

if data type is NATIONAL CHAR or
NATIONAL CHAR VARYING

NULL value in all other cases

NUMERIC_PRECISION

SMALLINT

Total number of significant digits

for numeric data types

NULL value in all other cases

NUMERIC_PRECISION_
RADIX

SMALLINT

Radix

for numeric data types

NULL value in all other cases

NUMERIC_SCALE

SMALLINT

Number of digits right of the decimal
point

for exact numeric data types

NULL value in all other cases

DATETIME_PRECISION

SMALLINT

Number of digits right of the decimal
point

for the data types TIME and
TIMESTAMP

NULL value in all other cases

Table 79: PARAMETERS view of the INFORMATION_SCHEMA (section 3 of 3)