Home > IT Answers > AS/400 > CPYTOIMPF --FLDDLM(*TAB) QUESTION
VRSTEEL
5 pts.
0
Q:
CPYTOIMPF --FLDDLM(*TAB) QUESTION
CPYTOIMPF, V5R4, DB2, DB2 Physical File
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...
ASKED: Mar 24 2009  6:19 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Philpl1jb
24105 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Mar 24 2009  6:39 PM GMT by Philpl1jb   24105 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Djac   675 pts.  |   Mar 25 2009  1:46PM GMT

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?

 
0