SQL Compiler Directive

When you compile a program that includes Embedded SQL statements, you must specify the SQL Compiler directive and appropriate options. The ODBC driver that your program calls depends on the particular data source that you are accessing.

You can specify the SQL directive anywhere where you can specify any other Compiler directive. For example:

in a $SET statement:
```
$set sql(dbman=odbc, autocommit)
```

on the cob command line:

cob -V testconn.cbl -C"anim SQL(DBMAN==ODBC)"

Note:

While you can specify the SQL directive more than once, we do not recommend it. Multiple sets of SQL directive options can conflict with one other causing certain options to be inadvertantly cancelled or overridden.