The following table contains the SQLDA data types. The data types are returned by the Adabas SQL Gateway Server for each column described by function 'SAGQDESC'. The relevant data type can be used to declare the type of host variable and indicator referenced by each column in the input or output SQLDA->SQLVAR.
|
SQLDA Data Type |
Value |
Description |
|
SQL_TYP_CHAR |
1 |
Character string |
|
SQL_TYP_NUMERIC |
2 |
Numeric |
|
SQL_TYP_DECIMAL |
3 |
Packed-Decimal |
|
SQL_TYP_INTEGER |
4 |
Integer (4 byte) |
|
SQL_TYP_SMALLINT |
5 |
Small Integer (2 byte) |
|
SQL_TYP_FLOAT |
6 |
Floating Point |
|
SQL_TYP_LARGEINT |
9 |
Large Integer (8 byte) |
|
SQL_TYP_VARCHAR |
12 |
Variable Length Character |
|
SQL_TYP_NUMERIC_LD |
20 |
Numeric Signed Leading |
|
SQL_TYP_NUMERIC_TR |
21 |
Numeric Signed Trailing |
|
SQL_TYP_NUMERIC_SLD |
22 |
Numeric Signed Leading Separate |
|
SQL_TYP_NUMERIC_STR |
23 |
Numeric Signed Trailing Separate |
|
SQL_TYP_NUMERIC_BINARY |
24 |
Numeric Binary (Little Endian) |
|
SQL_TYP_NUMERIC_BIN_BE |
25 |
Numeric Binary (Big Endian) |
|
SQL_TYP_NCHAR |
-1 |
Nullable Character string |
|
SQL_TYP_NNUMERIC |
-2 |
Nullable Numeric |
|
SQL_TYP_NDECIMAL |
-3 |
Nullable Packed-Decimal |
|
SQL_TYP_NINTEGER |
-4 |
Nullable Integer (4 byte) |
|
SQL_TYP_NSMALLINT |
-5 |
Nullable Small Integer (2 byte) |
|
SQL_TYP_NFLOAT |
-6 |
Nullable Floating-Point |
|
SQL_TYP_NLARGEINT |
-9 |
Nullable Large Integer (8 byte) |
|
SQL_TYP_NVARCHAR |
-12 |
Nullable Variable Length Character |
|
SQL_TYP_NNUMERIC_LD |
-20 |
Nullable Numeric Signed Leading |
|
SQL_TYP_NNUMERIC_TR |
-21 |
Nullable Numeric Signed Trailing |
|
SQL_TYP_NNUMERIC_SLD |
-22 |
Nullable Numeric Signed Leading Separate |
|
SQL_TYP_NNUMERIC_STR |
-23 |
Nullable Numeric Signed Trailing |
|
SQL_TYP_NNUMERIC_BINARY |
-24 |
Nullable Numeric Signed Leading Separate |
|
SQL_TYP_NNUMERIC_BIN_BE |
-25 |
Nullable Numeric Signed Trailing Separate |
|
SQL_TYP_BINARY |
-51 |
Nullable Numeric Binary (Little Endian) |
|
SQL_TYP_NBINARY |
-52 |
Nullable Numeric Binary (Big Endian) |
|
SQL_TYP_NATDATE |
-53 |
Binary |
|
SQL_TYP_NNATDATE |
-54 |
Nullable BINARY |
|
SQL_TYP_NATTIME |
-55 |
NATURAL DATE |
|
SQL_TYP_NNATTIME |
-56 |
Nullable NATURAL TIME |
|
SQL_TYP_SQLDA |
-57 |
SQLDA |
|
SQL_TYP_NATTIMESTAMP |
-58 |
NATURAL TIMESTAMP |
|
SQL_TYP_NNATTIMESTAMP |
-59 |
Nullable NATURAL TIMESTAMP |
|
SQL_TYP_SQLBIT |
-60 |
BIT |
|
SQL_TYP_NSQLBIT |
-61 |
Nullable BIT |