The data types specified in ODBC APIs are defined in terms of ODBC C types in the API definitions. The following table shows corresponding PL/I declarations for the indicated ODBC C types of the arguments.
| ODBC C type | PL/I form | Description |
|---|---|---|
| SQLSMALLINT | FIXED BIN(15) | Signed short integer (2 byte binary) |
| SQLUSMALLINT | FIXED BIN(16) UNSIGNED | Unsigned short integer (2 byte binary) |
| SQLINTEGER | FIXED BIN(31) | Signed long integer (4 byte binary) |
| SQLUINTEGER | FIXED BIN(31) UNSIGNED | Unsigned long integer (4 byte binary) |
| SQLREAL | FLOAT | Floating point (4 bytes) |
| SQLFLOAT | DOUBLE | Floating point (8 bytes) |
| SQLDOUBLE | DOUBLE | Floating point (8 bytes) |
| SQLCHAR * | CHAR(*) VARZ BYADDR | Pointer to unsigned character. |
| SQLHDBC | POINTER | Connection handle |
| SQLHENV | POINTER | Environment handle |
| SQLHSTMT | POINTER | Statement handle |
| SQLHWND | POINTER | Window handle |