The following table contains the SQLDA datatypes and their 3-digit values. Each datatype has two available values to indicate whether an occurrence of the datatype allows nulls. (For up-to-date information, see the current SQL manual.
Datatype |
Nulls not allowed |
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 |
