Previous Topic: Data Type of the Column and Null ValueNext Topic: SQLVAR and SQLTYPE

SQL Descriptor Area (SQLDA) › SQLDA (DESCRIBE or PREPARE INTO Statements) › Data Type of the Column

Data Type of the Column

The following applies when a value depends on the data type of the columns.

Field

Field

Data Type

Value

SQLVAR

SQLLEN

Any string

The length attribute of the column, that is, the maximum number of characters in a value

SQLVAR

SQLLEN

FLOAT

8

SQLVAR

SQLLEN

INTEGER

4

SQLVAR

SQLLEN

SMALLINT

2

SQLVAR

SQLLEN

DECIMAL(p,s)

p in byte 1
s in byte 2

SQLVAR

SQLLEN

NUMERIC(p,s)

p in byte 1
s in byte 2

SQLVAR

SQLLEN

DATE

10

SQLVAR

SQLLEN

TIME

8

SQLVAR

SQLLEN

TIMESTAMP

26