CA Datacom Server ODBC application is getting READ ONLY access when READ WRITE is desired.

Document ID : KB000056661
Last Modified Date : 14/02/2018
Show Technical Document Details

Scenario:

CA Datacom Server ODBC application is getting READ ONLY access when READ WRITE is desired. An application is getting the following ODBC error message when any write is attempted:

S1000(0)[CA][ODBC CA Datacom/DB Driver] No updates, deletes or inserts are allowed in SQLPrepare  

 

Resolution:

There are two settings to check …

 

First, check that the mainframe CA Datacom Server is started with option “ACCESS=W” (write) instead of “ACCESS=R”.

 From the CA Datacom Server User Guide Version 14.01:

“…
  ACCESS= 
  (Optional) Specifies the type of SQL access available in this Mainframe Server. 
  Valid Entries: R (read-only) or W (read/write)

  Default: W 

Note: ACCESS=R tells the Mainframe Server to reject SQL maintenance commands, such as INSERT, DELETE, UPDATE, and   CREATE. It does not affect locking mechanisms that the SQL engine uses in the Multi-User Facility to ensure data integrity.

…”

 

Second, check the Behavior in the Options table on the Datacom ODBC data source setup.

 From the CA Datacom Server User Guide Version 14.01:

“…

Set the ODBC Client Options

Optionally, you can edit cursor behavior, how tables are accessed, change auto commit, define table caching, limit the listed tables, and modify statement processing options of the server from the Options tab on the CA Datacom/DB ODBC Setup window.

 

Define the Behavior

You can change the access mode, the transaction level, and the cursor behavior when you select the Behaviors button.

Important! Value comparisons in SQL such as greater than and less than are passed to the mainframe and are executed there using EBCDIC collating sequence.

 

To define behavior when accessing data

1. Select the Behaviors button on the Options tab of the CA Datacom/DB ODBC Setup window.

The Cursor Behavior and Access Mode dialog appears.

2. Select READ/WRITE from the drop-down list in the Access Mode field.

…”

 

For additional information, refer to the CA Datacom Server User Guide 14.01 at:

https://support.ca.com/cadocs/0/CA%20Datacom%20Server%2014%200-ENU/Bookshelf_Files/PDF/DSV1401_User_ENU.pdf