Quick help needed! Moving records between OS400 database files.

[BOOKS1]

Hi, this is a very quick question & I would greatly appreciate any help!

On our v52 iseries, I archived some old records from a live file to an archive file. Unfortunately, the program (Arctools) I used doesn't provide the function to restore records from the archive file to the live file.

Is there a relatively easy way to restore/move records from one file to another on the iseries?

Many thanks
Keith
UK

 

[jmd0252]

If it is an actual PF,, ie physical file, and has the same format,, ie file structure,, then you can do a CPYF,,
Type choices, press Enter.

From file . . . . . . . . . . . from file Name
Library . . . . . . . . . . . fromlibr Name, *LIBL, *CURLIB
To file . . . . . . . . . . . . to file Name, *PRINT
Library . . . . . . . . . . . tolibr Name, *LIBL, *CURLIB
From member . . . . . . . . . . *FIRST Name, generic*, *FIRST, *ALL
To member or label . . . . . . . *FIRST Name, *FIRST, *FROMMBR
Replace or add records . . . . . *add *NONE, *ADD, *REPLACE...
Create file . . . . . . . . . . *NO *NO, *YES
Print format . . . . . . . . . . *CHAR *CHAR, *HEX

be sure to use *add,, in the replace or add option,, otherwise you can kill all the current records.