Copying device source files to database source files

 

When you copy from a device source file to a database source file, the system adds sequence number fields and date fields at the start of the records.

The system assigns the first record a sequence number of 1.00, the next 2.00, and so on, increasing in increments of 1.00. If more than 9999 records are copied, the sequence number wraps back to 1.00 and continues to increment unless you specify the SRCOPT and SRCSEQ parameters on the copy command.

If several copies to the same file are made with MBROPT(*ADD), you will have duplicate sequence numbers in the file. You can correct this using the Reorganize Physical File Member (RGZPFM) command.

Date fields are initialized to zeros.

When copying to or from a device, it is more efficient to use a device data file than a device source file. The copy function automatically adds or removes sequence number fields and date fields source sequence number and date fields as necessary.

 

Parent topic:

Adding or changing source file sequence number and date fields (SRCOPT and SRCSEQ parameters)