xx28 error-status executing SQL update statements

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

An attempt to run any SQL statement that will update the database (UPDATE/INSERT/DELETE) returns an unexpected error status of xx28.

Environment

Release: All supported releases.

Resolution

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 (offline).