Access Service User's Guide DirectConnect for AS/400

Column

Datatype

Description

PROCEDURE_QUALIFIER

varchar(128)

Always NULL

PROCEDURE_OWNER

varchar(128)

Value from the corresponding column of NULLID.SYSPROCCOL table

PROCEDURE_NAME

varchar(128)

NOT NULL

Name of the stored procedure

COLUMN_NAME

varchar(128)

NOT NULL

Name of the input parameter or result set column

COLUMN_TYPE

smallint

NOT NULL

Type of data in this procedure column:

• 1 SQL_PARAM_INPUT if the procedure column is an input parameter

• 3 SQL_RESULT_COL if the procedure column is a result set column

DATA_TYPE

smallint

NOT NULL

Integer code for the ODBC SQL datatype equivalent of the target database datatype for this procedure column

TYPE_NAME

varchar(128)

NOT NULL

String representing the datatype name in the target database

PRECISION

int

Precision of the procedure column on the target database; NULL if precision is not applicable

LENGTH

int

Length of the column in bytes

SCALE

smallint

Number of digits to the right of the decimal point; NULL if scale is not applicable.

RADIX

smallint

Base for numeric types; NULL if radix is not applicable

NULLABLE

smallint

Indicates whether the procedure column accepts NULL values:

• 0 means the column does not accept NULL

• 1 means the column accepts NULL

• 2 means it is not known if the column accepts NULL values

REMARKS

varchar(254)

Description of the procedure column