Need to use the cpytoimpf command but have problem

Tags:
CL Commands
CPYTOIMPF
iSeries Commands
I have an existing process that uses the following command the only change was to have it use the tildes (~) as a field delimiter.

CPYTOIMPF FROMFILE(*LIBL/BDPRISM) TOSTMF('/home/attach/vhaeom2/vhasales.txt') MBROPT(*REPLACE) STMFCODPAG(1252) RCDDLM(*CRLF) DTAFMT(*FIXED) STRDLM(*NONE) FLDDLM('~') But the command the command execute without error but the tilde is not place between the fields.  Below is a small section of the file.

AE0443010 120180C00 00071015623 LIPITOR TAB 20 AE0443010 120180C00 07061015520 KERR VIAL PLAST CR-20 180                     AE0443010 120180C00 07061014030 KERR VIAL PLAST PPV-30 AE0443010 120180C00 07061014060 KERR VIAL PLAST PPV-60

What am I doing wrong.

 



Software/Hardware used:
iSeries

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    CPYTOIMPF FROMFILE(*LIBL/BDPRISM) TOSTMF('/home/attach/vhaeom2/vhasales.txt') MBROPT(*REPLACE) STMFCODPAG(1252) RCDDLM(*CRLF) DTAFMT(*FIXED) STRDLM(*NONE) FLDDLM('~') If you want delimited fields, you need to specify DTAFMT(*DLM) instead of DTAFMT(*FIXED). Refer to the help-text for the DTAFMT() parameter. Note that DTAFMT(*DLM) is the normal default. Tom
    125,585 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following