Skip to main content

We are upgrading from NetExpress to Visual Studio/COBOL 8.0

We have a program that runs fine under NetExpress but with Visual COBOL it error with SQLCODE = 000019514-  (Cursor is not prepared)

The program is doing the first fetch fine but gets the error on the second fetch, we are doing an update on another table between the fetches but the DB connection is not being disconnected (like in other 19514 issue I have seen).

We are using transaction level commit, so a commit is done between the fetches.

Any help would be appreciated.

Thanks

We are upgrading from NetExpress to Visual Studio/COBOL 8.0

We have a program that runs fine under NetExpress but with Visual COBOL it error with SQLCODE = 000019514-  (Cursor is not prepared)

The program is doing the first fetch fine but gets the error on the second fetch, we are doing an update on another table between the fetches but the DB connection is not being disconnected (like in other 19514 issue I have seen).

We are using transaction level commit, so a commit is done between the fetches.

Any help would be appreciated.

Thanks

Can you publish a parial code with the sql statements.

i had no problem to move from netexpress5.x to visual cobol 8.x or now 9.x

The problem is sql-coding, but without the code any help is not possible

We are upgrading from NetExpress to Visual Studio/COBOL 8.0

We have a program that runs fine under NetExpress but with Visual COBOL it error with SQLCODE = 000019514-  (Cursor is not prepared)

The program is doing the first fetch fine but gets the error on the second fetch, we are doing an update on another table between the fetches but the DB connection is not being disconnected (like in other 19514 issue I have seen).

We are using transaction level commit, so a commit is done between the fetches.

Any help would be appreciated.

Thanks

Without the following information it is difficult to even try to help you:

OS and platform, Database and version, the relevant SQL Source code

We are upgrading from NetExpress to Visual Studio/COBOL 8.0

We have a program that runs fine under NetExpress but with Visual COBOL it error with SQLCODE = 000019514-  (Cursor is not prepared)

The program is doing the first fetch fine but gets the error on the second fetch, we are doing an update on another table between the fetches but the DB connection is not being disconnected (like in other 19514 issue I have seen).

We are using transaction level commit, so a commit is done between the fetches.

Any help would be appreciated.

Thanks

A difference between Net Express and Visual COBOL is that the behavior has changed regarding cursor handling after a COMMIT.

By default, cursors without WITH HOLD specified are closed automatically after a COMMIT is done.

To change this behavior you can set the following SQL directive:

SQL(CLOSE_ON_COMMIT=NO}

Terms & ConditionsAccessibility statement