As400 Developer Interview Questions and Answers

To copy a file from qry command, use CPYTOIMPF command.

• Use CPYTOIMPF command to copy a file from qry command

• Specify the file name and library in the command

• Specify the output file name and path in the command

• Use the correct format for the output file

• Example: CPYTOIMPF FROMFILE(QRYFILE) TOSTMF('/MYFOLDER/QRYFILE.CSV') MBROPT(*REPLACE) RCDDLM(*CRLF) DTAFMT(*DLM)

OVRDBF command is used to override the file being processed in a program with a different file.

• Used to temporarily change the file being processed in a program

• Helps in testing programs with different files without changing the program logic

• Can be used to redirect output to a different file