SQLDA Data Types
The following table contains the SQLDA data types. The data types are returned by the Adabas SQL Gateway Server for each column described by the 'SAGQDESC' function. 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