cpyfrmimpf-fail- reason code 7

[donna_ny]

I ve created PF with suitable lengths from XL sheet and tried to execute below :

CPYFRMIMPF FROMSTMF('/etc/XYZ/PQR/bga2/Firstname.csv') TOFILE(DLESTER
/FIRSTNAME) MBROPT(*REPLACE) RCDDLM(*CRLM) DTAFMT(*DLM) RPLNULLVAL(*FLDDFT)
--------------------
The copy did not complete for reason code 7.
The copy did not complete for reason code 7.
0 records copied to member FIRSTNAME.
Copy command ended because of error.
--------------------------

Message ID . . . . . . : CPC2959 Severity . . . . . . . : 00
Message type . . . . . : Completion
Date sent . . . . . . : 11/01/06 Time sent . . . . . . :

Message . . . . : 0 records copied to member FIRSTNAME.
Cause . . . . . : 0 records were copied from
/etc/XYZ/PQR/bga2/Firstname.csv. The records were copied to member or
label FIRSTNAME in file FIRSTNAME in library DLESTER. 2012 records were
not copied because they did not meet the selection requirements. Deleted
records were copied, and the number of records not copied were the result of
copy errors.
Technical description . . . . . . . . : If the from-file or to-file member
or label name is *N, the file is a printer, nonlabeled tape, or a spooled
inline file. If the from-file library name is *N, the file is a spooled
inline file. Records are copied based on the following selection
requirements:
-- Character values (INCCHAR parameter).
-- Field values (INCREL parameter).

----------------------------------
I could nt figure out whats wrong, I ve created DDS for PF with suitable lengths of fields from XL Sheet.
Any ideas

Donna.

[jamief]

Re: cpyfrmimpf-fail- reason code 7

Can you post the text file with a couple records init?

Thanks
jamie

[donna_ny]

Re: cpyfrmimpf-fail- reason code 7

20549,9991675,009991675,(JAMES) SKIP,BAKER,,206 XXXXXX,AAAA,TX,75287,T2,84UT130,DAAA,FFAA,AAWB,ANA AO,FFAA,2002-06-11 00:00:00,0,1,xxxx@xxxxx.com,AMERICAN,DROP N GO,AA,0,25,1,0,1,2006/09/30 2:15 PM

This is first rec in csv file, whats reason code 7 means?

[jamief]

Re: cpyfrmimpf-fail- reason code 7

the file you are copying into must have all 30 fields defined....
I did mine as all character 20 in length and ran the same command as you
and it worked fine.

My guess is either you dont have all 30 fields in your dds or
one field in your dds is defined an numeric and the field you are dumping
from the .csv has a bit of character in him.

[donna_ny]

Re: cpyfrmimpf-fail- reason code 7

hey Jamie
you are the greatest...

I defined all fields as char then it worked.
Thanks,
Donna

[jamief]

Re: cpyfrmimpf-fail- reason code 7

Thats nice of you to say.....but im just good at guessing but there are
some really bright people on the site that I couldnt do without.



jamie