Code the SQL access statements within the Working Storage Section and Procedure Division of your COBOL program. All SQL statements must be preceded by:
The Sqlcode declaration can be used in addition to, or in place of, the Sqlstate declaration. This is the method of error handling and error reporting through the SQL Communications Area (SQLCA), and the status variables
Sqlstate and
Sqlcode.
If table, parameter, or field names are invalid for COBOL, define valid names. This example defines the TDS table #ED_EMPLOYEES and assigns a valid COBOL name (MGRNO) to a TIBCO Object Service Broker field (MGR#):
Refer to Coding Considerations for information about assigning COBOL names to TIBCO Object Service Broker objects.
Refer to Syntax Mapping for conversions from TIBCO Object Service Broker syntax to COBOL declarations.