HCO Functions

Host Compatibility Option provides the following functions:

• Support of programs checked with CHARSET(EBCDIC)
• Support of DB2 for z/OS syntax DDL statements in programs and via a batch utility
• SQLCODE map function to translate SQLCODEs automatically from DB2 LUW value to a new, designated value
• A utility to do DCLGENs to produce INCLUDE COBOL copybooks of tables
• A DSNTIAR subroutine to translate SQLCODEs into expanded SQL error messages
• Quotes can be used as literals within SQL statements
• Dashes can be used within cursor definitions
• Support of the syntax

  SET host-variable = SPECIAL REGISTER

• Support of DECLARE TABLE statements
• Support of host variables with data structures (COBOL level numbers 01 through 48)
• Ability to use COMP data items for integer and small integer instead of the INTEL COMP-5 format
• Removal of the need to identify all host variables in Working-Storage via BEGIN DECLARE SECTION and END DECLARE SECTION statements
• Configurable CONCAT character ( | )
• Support of the NOT OPERATOR (¬) within queries
• Insertion of missing colon in fields when the SQL statement parameter must be a host variable
• Support of NOFOR compile option which allows updateable cursors to be defined without using the FOR UPDATE clause
• Support for alternate special register names, CURRENT_DATE, CURRENT_TIME, and CURRENT_TIMESTAMP
• Support for the DECLARE hostVariableName FOR BIT DATA statement