SQLDA Datatypes

Table F-3 contains the SQLDA data types and their 3-digit values. Each data type has two available values to indicate whether an occurrence of the datatype allows nulls. Use the value that describes how nulls are handled.

Table F-3: SQLDA datatypes

Datatype

Value, no nulls

Value, nulls allowed

DATE

384

385

TIME

388

389

TIMESTAMP

392

393

CHAR VARIABLE LENG

448

449

CHAR FIXED LENGTH

452

453

CHAR LONG VARIABLE

456

457

FLOATING-POINT

480

481

DECIMAL

484

485

LARGE INTEGER

496

497

SMALL INTEGER

500

501