SQL preprocessors

Choose from the SQL preprocessors supplied with Enterprise Developer to compile your applications.
OpenESQL
Before compiling from within Enterprise Developer:
  1. Open your project properties and click the SQL tab.
  2. From the ESQL Preprocessor drop-down list, select OpenESQL.
  3. Click Add; then click DBMAN on the list of directives.
  4. From the Value drop-down list, select ODBC or ADO; then click OK.
  5. To add another directive, select a directive from the Available Directives list.
  6. If required, provide details using the controls under Directive Details.
  7. Click OK. The directive is added to the SQL Directives field.
  8. Repeat this procedure to add additional directives.
DB2 ECM
  1. Open your project properties and click the SQL tab.
  2. From the ESQL Preprocessor drop-down list, select HCO for DB2 LUW.
  3. Click Add and choose DB from the list of directives, and click OK. Type the name of your database into the Value field of the directive details.
    Note: If you leave the value for DB blank, the compiler uses the database specified by the value of the DB2DBDFT environment variable.
XDB
  1. Open your project properties and click the SQL tab.
  2. From the ESQL Preprocessor drop-down list, select XDB.
  3. Configure the database in the Client Options console (Click Start > All Programs > Micro Focus Enterprise Developer> Data Tools > SQL Option for DB2 > Configuration > Client Options).
COBSQL
Before compiling from within Enterprise Developer:

For Oracle Pro*COBOL, you can set the COBSQL preprocessor and compiler directives from the SQL tab in your project properties:

  1. From the Solution Explorer, open your project properties, then click the SQL tab.
  2. From the ESQL Preprocessor list, select Oracle Pro*COBOL (COBSQL).
  3. Click Add, select a directive from the Available Directives list, then click OK. This places the directive in the Directives list.
  4. Optionally, you can change the details for a directive by selecting it from the Directives list and then modifying the fields and controls under Directive Details.
  5. Repeat the previous two steps to add additional directives.
    Note: When using this method, you can also specify Pro*COBOL directives to pass to the database precompiler by typing them directly into the Additional Directives field.
  6. Click Apply and then OK.
Note: Adding the Oracle Pro*COBOL (COBSQL) preprocessor to the SQL file or project property page automatically adds a read-only entry to the top of the preprocessors list in the SQL property page. If you have multiple preprocessors in the preprocessors list, you can change the sequence of execution by moving preprocessors up and down the list. See section Additional Preprocessors for more information.