Home > IT Answers > AS/400 > CPYTOIMPF –FLDDLM(*TAB) QUESTION
VRSTEEL
5 pts.
 CPYTOIMPF –FLDDLM(*TAB) QUESTION
CPYTOIMPF, DB2, DB2 Physical File, V5R4
Our OS is V5R4. I am using cpytoimpf to import .txt file (tab delimited) to DB2 physical file. If I remove the FLDDLM(*TAB), I get all the records but the fields have overlapped data. If I use the (*TAB) I get one record and errors on the remaining copy.(error code 7) Here is the command I am using. CPYFRMIMPF FROMSTMF('//CCGUPLOADS/corepcompm.txt') TOFILE(PURLIN/EPCOMPM) MBROPT(*REPLACE) RCDDLM(*CRLF) STRDLM(*NONE) RMVBLANK(*NONE) FLDDLM(*TAB) RPLNULLVAL(*FLDDFT) I am relatively new to using this statement... Thanks in advance...

Software/Hardware used:
ASKED: March 24, 2009  6:19 PM
UPDATED: March 25, 2009  1:46 PM
RELATED QUESTIONS
Answer Wiki:
As I understand it *TAB gives you one complete and correct record and uses all the fields in the first row of the input record then error... I would suspect the Record Deliminator is RCDDLM is not *CRLF Try CR if that doesn't work try LF here are some other record delimitors *LFCR *EOR If it doesn't match the actual record delimitor it trys to add more to the first record .. and gets error. Phil
Last Wiki Answer Submitted:  March 24, 2009  6:39 pm  by  philpl1jb   44,150 pts.
All Answer Wiki Contributors:  philpl1jb   44,150 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Have you checked that you don’t have any stray/additional tabs in the data in the input file? This could cause the data to be imported into invalid fields in the file (char into dec etc.)

Anything in the joblog relating to this?

djac
 900 pts.