HP OpenVMS Systems

Third-party tool and RMS? (CONNX ODBC)

» close window

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:
 
    ANALYZE/RMS/FDL/OUT=<fdl>
    EDIT <fdl>
    CONVERT/FAST/NOSORT/STAT/FDL=<fdl>
 

  

     

     
answer written or last revised on ( 17-JAN-2000 )
     
» close window