ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

CPYFRMIMPF unwanted x'25'

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • CPYFRMIMPF unwanted x'25'

    I have a comma separated file in the IFS that I am copying to a database file. For some reason in every row except the first row, it puts a x'25' in the first position of each record. There are 2 fileds in the DB file, both defined as alpha and 2 fields in the .csv

    Here is my command:

    CPYFRMIMPF FROMSTMF('/home/mfldr/xref.csv') TOFILE(mylib/XREF) MBROPT
    (*REPLACE) RCDDLM(*LF) FLDDLM(',')
    671 records copied to member TXT.
    Copy command ended because of error.


    Any ideas woulld be appreciated

  • #2
    Re: CPYFRMIMPF unwanted x'25'

    Well, I changed the RCDDLM(*LF) to RCDDLM(*ALL) and that solved the problem.

    Comment

    Working...
    X