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

Using the supplied include files

The include files described and listed here are for ODBC Version 3.0.

Table 20. Supplied include files for ODBC
File name Description
ODBCSQL.CPY Main include for ODBC functions
ODBCEXT.CPY Include for Microsoft's ODBC extensions
ODBCTYPE.CPY Include for ODBC type definitions
ODBCUCOD.CPY Include unicode
ODBCSAMP.PLI Sample program

The supplied include files define the symbols for constant values described for ODBC APIs, mapping constants used in calls to ODBC APIs to symbols specified in ODBC guides so that argument (input and output) and function return values can be specified and tested. These files should be included in your PL/I program in order to use ODBC API calls.

In PL/I, names longer than 31 characters are truncated or abbreviated to 31 characters. Table 21 shows the names that are longer than 31 characters, and their corresponding PL/I names.

Table 21. ODBC names truncated or abbreviated for PL/I
ODBC C #define symbol > 31 characters long Corresponding PL/I name
SQL_AD_ADD_CONSTRAINT_DEFERRABLE SQL_AD_ADD_CONSTR_DEFERRABLE
SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED SQL_AD_ADD_CONSTR_INITLY_DEFERD
SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE SQL_AD_ADD_CONSTR_INITLY_IMMEDT
SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE SQL_AD_ADD_CONSTR_NON_DEFERRABL
SQL_AD_CONSTRAINT_NAME_DEFINITION SQL_AD_CONSTR_NAME_DEFINITION
SQL_API_ODBC3_ALL_FUNCTIONS_SIZE SQL_API_ODBC3_ALL_FUNCTIONS_SZ
SQL_AT_CONSTRAINT_INITIALLY_DEFERRED SQL_AT_CONSTR_INITIALLY_DEFRD
SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE SQL_AT_CONSTR_INITIALLY_IMMED
SQL_AT_CONSTRAINT_NAME_DEFINITION SQL_AT_CONSTR_NAME_DEFINITION
SQL_AT_CONSTRAINT_NON_DEFERRABLE SQL_AT_CONSTR_NON_DEFERRABLE
SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE SQL_AT_DROP_TBL_CONSTR_CASCADE
SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT SQL_AT_DROP_TBL_CONSTR_RESTRICT
SQL_CA_CONSTRAINT_INITIALLY_DEFERRED SQL_CA_CONSTR_INITLY_DEFERRED
SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE SQL_CA_CONSTR_INITLY_IMMEDIATE
SQL_CA_CONSTRAINT_NON_DEFERRABLE SQL_CA_CONSTR_NON_DEFERRABLE
SQL_CDO_CONSTRAINT_NAME_DEFINITION SQL_CDO_CONSTR_NAME_DEFINITION
SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED SQL_CDO_CONSTR_INITLY_DEFERRED
SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE SQL_CDO_CONSTR_INITLY_IMMEDIAT
SQL_CDO_CONSTRAINT_NON_DEFERRABLE SQL_CDO_CONSTR_NON_DEFERRABLE
SQL_CT_CONSTRAINT_INITIALLY_DEFERRED SQL_CT_CONSTR_INITLY_DEFERRED
SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE SQL_CT_CONSTR_INITLY_IMMEDIATE
SQL_CT_CONSTRAINT_NON_DEFERRABLE SQL_CT_CONSTR_NON_DEFERRABLE
SQL_CT_CONSTRAINT_NAME_DEFINITION SQL_CT_CONSTR_NAME_DEFINITION
SQL_DESC_DATETIME_INTERVAL_PRECISION SQL_DESC_DATETIME_INTERVAL_PREC
SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR SQL_DL_SQL92_INTERVAL_DAY_TO_HR
SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE SQL_DL_SQL92_INTERVAL_DY_TO_MIN
SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND SQL_DL_SQL92_INTERVAL_DY_TO_SEC
SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE SQL_DL_SQL92_INTERVAL_HR_TO_MIN
SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND SQL_DL_SQL92_INTERVAL_HR_TO_SEC
SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND SQL_DL_SQL92_INTERVAL_MN_TO_SEC
SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH SQL_DL_SQL92_INTERVAL_YR_TO_MTH
SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 SQL_FORWARD_ONLY_CURSOR_ATTRIB1
SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 SQL_FORWARD_ONLY_CURSOR_ATTRIB2
SQL_MAX_ASYNC_CONCURRENT_STATEMENTS SQL_MAX_ASYNC_CONCURRENT_STMTS
SQL_MAXIMUM_CONCURRENT_ACTIVITIES SQL_MAXIMUM_CONCURRENT_ACTIVITI
SQL_SQL92_FOREIGN_KEY_DELETE_RULE SQL_SQL92_FOREIGN_KEY_DEL_RULE
SQL_SQL92_FOREIGN_KEY_UPDATE_RULE SQL_SQL92_FOREIGN_KEY_UPD_RULE
SQL_SQL92_NUMERIC_VALUE_FUNCTIONS SQL_SQL92_NUMERIC_VALUE_FUNCT
SQL_SQL92_RELATIONAL_JOIN_OPERATORS SQL_SQL92_RELATIONAL_JOIN_OPER
SQL_TRANSACTION_ISOLATION_OPTION SQL_TRANSACTION_ISOLATION_OPTN
SQL_TRANSACTION_READ_UNCOMMITTED SQL_TRANSACTION_READ_UNCOMMITTD
Rational Developer for System z
PL/I for Windows, Version 8.0, Programming Guide