The Question is:
I am trying to update a field in an RMS file via a CONNX ODBC driver. When I
try to update the field I get the SQL message: ERR:99484...invalid key
change in $UPDATE (CHG) not set. The field consists of the first column only
and is in what I believe to be
the primary key. The KEY$V_CHGKEYS flag does not appear on an ANALYZE
report for this key.
How can I change this field?
The Answer is :
For starters, RMS does NOT allow changes to PRIMARY keys, only for
secondary keys. Changing primary keys can only be achieved by a
sequence of a READ, a DELETE, and a re-WRITE. This is how COBOL
implements REWRITE -- for information on CONNX and how CONNX (tries
to) perform this, please contact CONNX support.
Secondary key values can be changed, if that was enabled when the
file was created -- this is a permanent file attribute. To change
that attribute, you will need to use the following sequence: