When I execute the following code:
...I get the following error:
There were a total of 3 records (plus a header) in the tab file. The record that did not get copied had a comma in the invoice amount field (5,432.10). I don't recall having a problem with this before but it's very possible I have never processed numeric data with commas before. One of the values had a negative sign (-43.21) and it copied correctly.
Am I missing something or is this the way it has always been?
Code:
CPYFRMIMPF FROMSTMF(&LST_FILENAMES) + TOFILE(QTEMP/FILELIST) MBROPT(*ADD) + RCDDLM(*CRLF) STRDLM(*NONE) + STRESCCHR(*NONE) RMVBLANK(*BOTH) + FLDDLM(*TAB) DECPNT(*PERIOD) DATFMT(*USA) + TIMFMT(*HMS) RPLNULLVAL(*FLDDFT) + RMVCOLNAM(*YES)
Code:
The copy did not complete for reason code 7. 7 - The FROMFILE numeric field INVAMOUNT contains blank characters, or other characters that are not valid for a numeric field.
Am I missing something or is this the way it has always been?
Comment