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”.
(Optional) Specifies the type of SQL access available in this Mainframe Server.
Valid Entries: R (read-only) or W (read/write)
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.
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.
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.