Conference iosg::all-in-1_v30

606.0. "WRITE ADD Limitation?" by RT95::BYRNE (The Red Menace) Wed Apr 29 1992 23:09

I am trying to set up a simple archiving system for one of my customers.

The customer has a number of related indexed files.  Each of the files
has many fields.  I want to allow the user to select a record, have it
appear in the current item block and then type a menu choice allowing
him to archive the selected record (and all related records on the other
files) to be archived to archive files.

A script would be executed to do a WRITE DELETE on all affected indexed files,
and then a WRITE ADD to add the records to the appropriate archive files.
Sounds simple, but I don't want to have to do 
	a WRITE ADD KEY = #KEY, -
	            FIELD1 = #FIELD1 ,-
		         .
			 .
		    FIELDZILLION = #FIELDZILLION

         for EVERY one of the 8 files.

Is there any way I can write a whole record to another file without having
to deal with each of its fields?

Eileen
               

    
    Eileen,
    
    If the fields in the 8 different data sets have the same name, why not
    write the record selected to a dummy data set, merge the record from
    this data set into the other data sets via OA$CNV_MERGE and then delete
    the dummy data set (or the record from the dummy data set).
    
    Just an idea.
    
    	Simon

    Or use the DATA_FILE function?
    
    Tony