The include files described and listed here are for ODBC Version 3.0.
| 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 23 shows the names that are longer than 31 characters, and their corresponding PL/I names.
| 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 |