SQL update requests can run into an xx28 error-status.

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

Introduction: 

Update of an SQL table (UPDATE/INSERT/DELETE) returns an unexpected error status.

 

Question: 

When I try to update an SQL table, I get a DB001031 error message indicating an 0828 error status from DBMS.

Is this the correct status? Shouldn't it be an 0866 or 0966?

 

Environment:  

IBM z/OS

 

Answer: 

When an SQL command is processed, IDMS will prepare the data areas, by default, in a mode that allows both update and retrieval. If the areas cannot be readied in read-write mode, they will be readied in read-only mode instead.

If the areas are readied in read-only mode and an UPDATE command is issued, the 0828 is issued on the DB001031 to indicate this. For an INSERT statement, a 1228 error status is returned. For a DELETE statement, a 0228 error status is returned.

An xx66 minor code would indicate that the area was not available at all.