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.
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.
Comment