Re: Transferring a CSV file to i5

[Pat Barber <mboceanside@xxxxxxx>]

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') +
>                TOFILE(KDICHANGES/AUDITCSV) +
>                MBROPT(*REPLACE) RCDDLM(*CRLF) +
>                ERRRCDFILE(KDICHANGES/AUDITERORS +
>                AUDITERORS) ERRRCDOPT(*REPLACE)
> 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
> allowed.
> 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
>    parameter.
>
> I have the TOFILE created as:
>                        
>   R AUDITMEM
> ----------------------
>     SSN            4
>     MBRTYPE        4
>     NAME          35
>     SEQNUM         9
>     ADRSLN1       35
>     CITY          35
>     STATE          2
>     ZIP            5
>     ENRDT          8
> The file is 130chs long.
> I have created an error file called AUDITERORS
>
> I have created the error file as:
>                        
>    R AUDITMEM
> ----------------------
>      RECORD       200
> 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?
>
> Thanks,
>
> Gary Kuznitz