Program using OpenESQL gets compile errors when moving from Net Express to Visual COBOL

0 Likes
over 8 years ago

Problem:

Customer has a program that uses embedded SQL statements using the OpenESQL precompiler.
This program compiles without errors under Net Express but when compiling under Visual COBOL as a native program it gets the following error:

COBCH0801: Statement Incompatible with BEHAVIOR setting
on the following statement:
      EXEC SQL SET CONCURRENCY READ-ONLY END-EXEC

Why is this occurring?

Resolution:

This error message occurs because the default settings of the SQL BEHAVIOR directive have changed in Visual COBOL.

By default it is now set to BEHAVIOR=MAINFRAME if it is not specified.
You can change this behavior back to the Net Express defaults as follows:

Close Visual Studio and then in the C:\Program Files\Micro Focus\Visual COBOL\bin folder run the program esqlconfigw.exe.

Click on the third option down which is for no change in behavior and then click the save button.

Open up Visual Studio and try compiling again.
The error message should now be gone.

Comment List
Anonymous
Related Discussions
Recommended