CPYFRMIMPF command to copy file from IFS to database file

40 pts.
Tags:
AS/400
CPYFRMIMPF
I am using this command to copy a file from the IFS to a database file.
CPYFRMIMPF FROMSTMF('tempACATACCT.csv') TOFILE(DVLLIB/ACATACCT) MBROPT(
*ADD) RCDDLM(*CRLF) DTAFMT(*DLM) STRDLM(*NONE) RMVBLANK(*NONE) FROMRCD(*F
IRST) ERRRCDOPT(*REPLACE) RPLNULLVAL(*FLDDFT) IDCOL(*FROMFLD) RMVCOLNAM(*
YES)
93 records copied to member ACATACCT. The problem is there are 94 records in the file, the first 1 which I can see with the WRKLNK command is being dropped. No error logs/messages are being created.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

RMVCOLNAM(*YES)

Should this be *NO ???

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • philpl1jb

    RMVCOLNAM(*YES)

    Should this be *NO?

    54,090 pointsBadges:
    report
  • TheRealRaven
    Since CPYFRMIMPF defaults to ERRLVL(*NOMAX) and you didn't specify ERRRCDFILE(), how can you tell if there were no errors?
    35,190 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: