CPYTOIMPF is for copying files from the AS/40 to the IFS. Not directly to the PC. Once you have the file on the IFS you will then need to find a way to get it to the user. You can do this by either mapping a drive, FTP, or email.

Error number 3025 is for “No such path or directory”. If it exist you may not have authority to it.

CPYTOIMPF FROMFILE(TESTSUB/TRUCKPF) +
TOSTMF(‘D:/example/TC1.CSV’) MBROPT(*ADD) +
RCDDLM(*CRLF) DTAFMT(*DLM)

I want the file truckpf to be transfered to tc1.csv in the d directory.
but iam getting an error “Copy command ended because of error”

Please help me…………….

’D:/example/TC1.CSV’
D: is how the folder looks from your PC side but the 400 looks at things differently
If you have authority WRKFLR will probably give you the path
The path will actually begin with a / so it might be /myfldr/mysubfldr/example/TC1.CSV

You will also want to look into job logs for more error messages.
Phil

CPYTOIMPF FROMFILE(TESTSUB/TRUCKPF) +
TOSTMF(’D:/example/TC1.CSV’) MBROPT(*ADD) +
RCDDLM(*CRLF) DTAFMT(*DLM)

CPYTOIMPF is an AS/400 command. AS/400s don’t have D: drives. Your AS/400 has no clue what a D: drive is. Since there are probably multiple PCs in your network, there might be a different D: drive on each PC; the AS/400 would have no way of knowing which D: drive it was.

You need to specify a path that is visible from a program running inside the AS/400.

Phil probably made a typo and intended to specify the WRKLNK command.

Tom

No Tom,
WRKFLR, work with folders, or am I showing my age.

We both assumed that your D drive was a mapped drive on the I-series IFS.
The file must be in a folder on the i-series to use the CPYTOIMPF command.
Oguk

The file must be in a folder on the i-series…

No. It must be in a directory but not necessarily in a folder. (CPYTOPCD requires a folder.)

Also, the question says “to pc”. The only AS/400 copy target that will get to a PC will be in the /QNTC file system (or a mounted NFS directory). Copying to a folder doesn’t get out of the AS/400. The OP would need to do some copy function on the PC via a mapped drive to do the copying “to pc” if the AS/400 target was a folder.

WRKLNK will work over folders as well as directories that are not folders. WRKFLR only works with “folders”.

However, it’s indeed possible that the OP was leaving some details out and didn’t really mean “to pc”. It could indeed mean “to some location that my pc can access in order to do the copy to pc”.

Tom

Then again, this isn’t about the OP… hmmm… complications…

That’s one problem with adding to an existing thread. If circumstances are different, it should go in a different thread.

Tom

Right Tom,

Too much to do, too little time.
CPYTOIMPF can copy an AS/400 file to an AS/400 directory.
A seperate step is necessary to copy that file to your PC.

Phil