Update of an SQL table (UPDATE/INSERT/DELETE) returns an unexpected error status.
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?
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.