Directives
UPDATE Update Existing Record in File
   
Formats UPDATE (chan[,fileopt])varlist

Where:

chan Channel or logical file number of the file to which to write.
fileopt Supported file options (see also, File Options):
BSY=stmtref Traps Error #0: Record/file busy
DOM=stmtref Missing record transfer
END=stmtref End-Of-File transfer (File full)
ERR=stmtref Error transfer
IND=num Record index
KEY=string$/num Record key
REC=name$ Record prefix (REC=VIS(string$) can also be used)
RTY=num Number of retries (one second intervals)
SIZ=num Number characters to read
TBL=stmtref Data translation table
TIM=num Maximum time-out value in integer seconds.
stmtref Program line number or statement label to which to transfer control.
varlist Comma-separated list of variables, literals, or IOL= options.
   
Description The UPDATE directive is used to update an existing record to a file (logical file number / channel). The syntax for this directive is identical to the WRITE Directive; however, UPDATE only updates a record if it already exists and will return an error if the record does not exist.

UPDATE may be used against Keyed, Memory, ODBC, and OCI files.

When IND= is used with *MEMORY*, this directive overwrites an existing index.

   
See Also WRITE Add/Update Data in File
WRITE RECORD Write Record
INSERT Insert New Record in File