Micro Focus Visual COBOL 2.3 for Eclipse (Windows) > Programming > Data Access > Database Access > OpenESQL > Setting the OpenESQL Preprocessor and Compiler Directive Options

Setting the OpenESQL Preprocessor and Compiler Directive Options

You can specify the OpenESQL preprocessor and its directive options using any of the following methods:

In your Visual COBOL Project

Before compiling from within Visual COBOL:

Open your project properties and expand Micro Focus > Project Settings > COBOL > SQL Preprocessor.
Note: You can also set compiler directive options under Micro Focus > Build Configurations > COBOL > SQL Preprocessor. If you do this, the setting applies only when the build configuration is active, and the compiler directive option is not set to something else in the Project Settings or on the program level.
If unchecked, check Enable configuration specific settings and Use SQL Preprocessor.
From the Preprocessor Type drop-down list, select OpenESQL.
Type the name of your database into the Value field of the DB setting.
To specify the type of database access you want, use the grid to set the value of the DBMAN directive to ODBC or JDBC.
Click Apply.
Use the grid to select additional directive options and set appropriate values. Click Apply after each setting.

Alternatively, you can enter the preprocessor specification and options as additional directives:

Open your project properties and expand Micro Focus > Project Settings > COBOL.
Note: You can also set the preprocessor under Micro Focus > Build Configurations > COBOL. If you do this, the setting applies only when the build configuration is active, and the preprocessor is not set to something else in the Project Settings or on the program level.
Click in the Additional directives field and type:
```
SQL(DBMAN=dbaType [SQLdirOpt])
```
Where dbaType is ODBC or JDBC, and SQLdirOpts is one or more additional directive options.

On the Command Line

Use the SQL compiler directive, followed by the DBMAN option to specify the type of database access:

SQL(DBMAN=dbaType) (Windows)

Or:

SQL(DBMAN==dbaType) (UNIX)

Where dbaType is ODBC or JDBC.

In a Directives File

You can include OpenESQL preprocessor directives in the cobol.dir system-wide directives file, a user directives file, or both. See System-wide Directives File, cobol.dir and User Directives File for details.

Embedded in a Program

You can also specify the OpenESQL preprocessor and compiler directive options on the program level by embedding a $SET statement into the program itself starting in column 1 on the first line of the program:

$SET SQL(DBMAN=dbaType [SQLdirOpts])

Where dbaType is ODBC, or JDBC, and SQLdirOpts is one or more additional directive options.

Important: Use this method only when the program requires a preprocessor different from other programs in an application.