DB2 Table Locked

Hi,

What product and version are you using and under what platform?

What method are you using to access DB2, using the DB2 ECM (DB2 directive) or using OpenESQL (SQL(DBMAN=ODBC directive)?

Are you executing a COMMIT after the INSERT?

Chris,

I'm running Microfocus Enterprise Developer version 2.2.244v201310050344, under Windows 7 32-bit. The program is compiled using Enterprise Cobol for Z/OS.

I'm using the preprocessor type XDB, with no SQL Directives.

Commit is not executed in the program, but I ran a test executing it and the table was released for viewing.

Am I obligated to use Commit ?

Thanks !

Chris,

I'm running Microfocus Enterprise Developer version 2.2.244v201310050344, under Windows 7 32-bit. The program is compiled using Enterprise Cobol for Z/OS.

I'm using the preprocessor type XDB, with no SQL Directives.

Commit is not executed in the program, but I ran a test executing it and the table was released for viewing.

Am I obligated to use Commit ?

Thanks !

Chris,

I'm running Microfocus Enterprise Developer version 2.2.244v201310050344, under Windows 7 32-bit. The program is compiled using Enterprise Cobol for Z/OS.

I'm using the preprocessor type XDB, with no SQL Directives.

Commit is not executed in the program, but I ran a test executing it and the table was released for viewing.

Am I obligated to use Commit ?

Thanks !

XDB is the Micro Focus database that emulates IBM DB2 in Development and is not actually a DB2 database. XDB is not available in Visual COBOL so I will be moving this post to the Enterprise Developer forum so that somebody better qualified can respond.

Thanks.