× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. June 2005

CPYFRMIMPF & ERRRCDFILE

I am using CPYFRMIMPF to get data from a comma separate file to a database 
file.  I have specified an Error record file on the copy command.  However, 
when I do get errors, I am unable to read the records.  Does anyone know how to 
make the data in the error file readable?  Operating system is at V5R3.

I created the error file with a record lenght = TOFILE record length + TOFILE 
number of fields + 813 (779+48+813=1640).  Here is the CRTPF command I used.
CRTPF FILE(MYLIB/ERRORFILE) RCDLEN(1640) FILETYPE(*SRC)   

Here is the CPYFRMIMPF command I used.
CPYFRMIMPF FROMSTMF('/home/mycsv.csv') TOFILE(MYLIB/MYFILE) MBROPT(*REPLACE) 
RCDDLM(*CRLF) ERRLVL(*NOMAX) ERRRCDFILE(MYLIB/ERRORFILE) ERRRCDOPT(*REPLACE) 
RPLNULLVAL(*FLDDFT)

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.