Hi Thea,

What version of Visual COBOL do you have installed?
What version of the VSCode extension are you using? (click on extensions from side menu and then click on Micro Focus COBOL.)

This works fine for me when building if I add the SQL directive in a $SET statement in column 7 at the top of the program, or I add the SQL directive directly in the .bat file I am using as a custom build task.

It also works for debugging if I add the directive to the default list of directives under Preferences.

Hi Chris,

I am using extension version of 1.0.55.

May I request what is inside the .bat file? Actually this is the first time that I am using Visual COBOL. All the $SET or directives are new to me.

Is it ok for me to ask, a sample program you are using that has SQL? I would like to try on my machine and see if I am missing anything.

Also, how to determine what version of Visual COBOL I have?

I am not sure, all of the support I am seeing, to determine what version of Visual COBOL is only applicable for Visual Studio and not for VSCode? Correct me if I am wrong Chris.

I maybe lacking some setups on my machine to make a COBOL-DB2 work on my side.

cob -V

Will tell you what version and patch update you have. cob is the cobol compiler

Thank you Micheal.

Hi Chris,

Currently my machine has:

Micro Focus COBOL version 9

Extension Version: 1.0.55

Under which operating system are you running? I have been assuming that you were running on Windows, but it sounds like it may be Linux. 

The test program that I am using simply has a connect statement in it and it doesn't even have to connect to a real connection because this is a compile time error.

I am running on Windows 10.

I tried your code and giving me "error COBCH0170 : Invalid argument in sql(dbman=ODBC)"

I have put $SET sql(dbman=ODBC) at column 7.

I also tried removing the default directive sql, leaving with only the following directives: int(), anim, nognt, errformat(3)

Did you build yours using a .bat file? I am not an expert with the .bat file, can you please share with me if there is a set need there as well?

I am running the code using these Run COBOL program button.

I created a file buildit.bat which contains the following line:

cobol VSCodeDB.cbl/int() anim;

Then I selected from the menu, Terminal->Configure Tasks

and added the following to the tasks.json file:

Then select Terminal->Run Build Task or Run Task and select the "my custom build"

This should compile the program.

I am using identical versions and OS that you are, and this is working for me.

sorry I have a missing comma in my task file. Please use this instead:

There is nothing difference between the default directive and the .bat file. 

Though, I still try to run via .bat file. Still same error

"Invalid argument in SQL(DBMAN=ODBC)"

I wonder what I am missing? Is there specific .dll file that my machine should be having?