Can SQL(CHECK) option be used when using TARGETDB=ORACLEOCI?

0 Likes
over 8 years ago

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.

Comment List
Anonymous
Related Discussions
Recommended