Generating EXEC SQL Auxiliary Code

OpenESQL Assistant can generate the following types of EXEC SQL auxiliary code:

• CONNECT Statement

  Generates a CONNECT statement based on known information about your current data source connection.

• Type 6 CONNECT statement

  Generates a type 6 CONNECT statement, allowing the application to connect to data sources that are not cataloged.

• SQLCA Declaration

  Generates an INCLUDE statement to include an SQL Communications Area (SQLCA) in your program.

• Host Variable Declarations

  For each table that you have selected, the OpenESQL Assistant generates a copybook that includes all of the host variable declarations you need. The OpenESQL Assistant can also generate the INCLUDE statement necessary to include the copybook in your program.

• OpenESQL Assistant DISCONNECT Statement

  Generates a DISCONNECT statement to disconnect from the current data source.

• COMMIT Statement

  Generates a COMMIT statement to commit changes to a data source issued from a previous SQL statement.

• ROLLBACK Statement

  Generates a ROLLBACK statement to rollback changes to a data source issued by a previous SQL statement or statements.

• Generic SQL Program

  Generates a skeleton SQL program that includes the INCLUDE SQLCA, CONNECT and DISCONNECT SQL statements and a default SQL error routine.