visual cobol db2 connect

 I'm tyring to connect to AS/400 db2 and compile COBOL DB2 programs, but  I cannot find any anwser by google or your community(the link in the related quesitons' anwser all displayed "The current document displayed does not exist in the table of contents" after clicking it), can you please help? 

Which COBOL product are you using Visual COBOL for Visual Studio, Visual COBOL for Eclipse or Visual COBOL DevHub and on what platform Windows, Linux or Unix?

To what documentation link are you referring?

Visual COBOL supports 4 methods of connecting to DB2 in order to use embedded SQL but these are dependant on what product and platform you are using. 

The DB2 ECM is used in conjunction with the embedded preprocessor from IBM and is normally used to connect to DB2 LUW. I am not rteally sure if this can be used to connect to DB2 running on the AS/400. It would be best to ask IBM about that option.

The other options involve using the Micro Focus embedded SQL preprocessor known as OpenESQL. This connects to various databases thru ODBC if you are using native code or thru ADO if using .NET code or thru JDBC if you are copmpiling to JVM byte code.

The specific drivers to use in these connections are provided by IBM and not by Micro Focus.

This is covered in the documentation here:

Thank you for your answer. I'm working on visual cobol for eclipse on windows 10. 

For example: the link in the answer in below link is not working.

https://community.microfocus.com/t5/Visual-COBOL-Forum/How-to-connect-to-db2-database-using-visual-cobol/m-p/1726833?advanced=false&collapse_discussion=true&filter=location&location=forum-board:forumid-18&q=db2 connect&search_type=thread

Which COBOL product are you using Visual COBOL for Visual Studio, Visual COBOL for Eclipse or Visual COBOL DevHub and on what platform Windows, Linux or Unix?

To what documentation link are you referring?

Visual COBOL supports 4 methods of connecting to DB2 in order to use embedded SQL but these are dependant on what product and platform you are using. 

The DB2 ECM is used in conjunction with the embedded preprocessor from IBM and is normally used to connect to DB2 LUW. I am not rteally sure if this can be used to connect to DB2 running on the AS/400. It would be best to ask IBM about that option.

The other options involve using the Micro Focus embedded SQL preprocessor known as OpenESQL. This connects to various databases thru ODBC if you are using native code or thru ADO if using .NET code or thru JDBC if you are copmpiling to JVM byte code.

The specific drivers to use in these connections are provided by IBM and not by Micro Focus.

This is covered in the documentation here:

There is no option for system i database or something like that in TARGETDB of Directives in Visual COBOL-project->properties->Micro Focus->sql processor, does this mean that Visual cobol do not support DB2 on Iseries?

You can select TARGETDB=DB2 or you can leave it blank. This directive is only to turn on optimization for a particular database vendor, it does not actually establish the connection to the database. When using OpenESQL you use the Windows ODBC Datasource Administration tool to set up your DSN pointing to your particular iSeries ODBC driver and then you can connect to this DSN from within your program using EXEC SQL CONNECT...

The actual ODBC driver you need to get from IBM and it must be the same bitism as the program you are compiling. If you are compiling to 32-bit then you need to create your DSN using the 32-bit ODBC Datasource administrator and if you are compiling to 64-bit you need to create your DSN using the 64-bit version of this tool. On Windows 10 you can launch this from the search window by typing ODBC and selecting the correct version.

I connected it by using ODBC, but here comes a new problem. I can read the database but cannot update it. The SQLCODE when run the update statement in visual cobol is 0, but it is acutally not updated in DB.