If you have Access, use the send file to host option
and then the tools option to create the file. It's
really pretty simple.
I would guess that your file layout is missing some field.
By trying this method, at least you will get a good layout.
On 2/10/2014 5:46 PM, Gary Kuznitz wrote:
I'm trying to transfer a .CSV file to an i5.
I tried using this cmd:
CPYFRMIMPF FROMSTMF('/home/garyt/LU127720140115.csv') +
MBROPT(*REPLACE) RCDDLM(*CRLF) +
I'm getting this error:
Message ID . . . . . . : CPF2885 Severity . . . . . . . : 30
Message type . . . . . : Diagnostic
Date sent . . . . . . : 02/10/14 Time sent . . . . . . : 14:35:04
Message . . . . : Field Definition or Error file AUDITERORS in KDICHANGES not
Cause . . . . . : File AUDITERORS in KDICHANGES is not the correct file type
for the copy command.
-- The Copy From Import File (CPYFRMIMPF) command require a source, DDM,
program described physical, or externally described physical file for the
Field Definition File (FLDDFNFILE) and the Error Record File (ERRRCDFILE).
Recovery . . . : Do one of the following to change the file name on the
parameter and try the request again:
-- Specify the correct file type on the FLDDFNFILE, or ERRRCDFILE
I have the TOFILE created as:
The file is 130chs long.
I have created an error file called AUDITERORS
I have created the error file as:
It has a member.
Does anyone have any ideas what could be wrong with the type of the error file?
Or what I am doing wrong?