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.
June 17, 2011 6:55 PM
June 20, 2011 1:15 PM