Rational Developer for System z
PL/I for Windows, Version 8.0, Programming Guide

Mapping of ODBC C types

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.

Table 24. Mapping of ODBC C Type to PL/I Data Declarations
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

Terms of use | Feedback

This information center is powered by Eclipse technology. (http://www.eclipse.org)