Problem:
Customer is accessing an Oracle database via OpenESQL (not Pro*COBOL).
They need to check the sql syntax at compilation time.
They are using the following directive:
SQL(TARGETDB=ORACLEOCI)
Is it possible to use the SQL(CHECK) directive to pass the embedded sql statements to Oracle at compile time for syntax checking?
Resolution:
SQL(CHECK) is not supported with TARGETDB=ORACEOCI. To use SQL(CHECK), you need to use the DBMAN=ODBC directive.
ORACLEOCI is being deprecated.