Hello, I'm having trouble copying a file to a csv on the PC network. The file is created from a query, and all the fields (numeric and alpha) copy fine except for two. These two fields were created using the Define Result Fields option in the query (BANKID = '00001' and MATCODE = 'M'). The two columns appear as garbage in the csv file. It makes no sense to me that these two fields are garbled, when Char fields pulled from files come out just fine. They all look the same in a DSPFFD of the output file.
Here is the command I'm using:
If I copy the file using iAccess Data Transfer, it works fine, so there must be a problem with my parameter options, but I have tried a variety of other options with no effect. Any suggestions please?
Here is the command I'm using:
Code:
[COLOR=#1f497d][FONT=Calibri]CPYTOIMPF FROMFILE(LIBNAME/FILENAME) TOSTMF('\groups\common\Test.csv') MBROPT(*REPLACE) STMFCCSID(*PCASCII) RCDDLM(*CRLF) FLDDLM(?,?) STRDLM(*NONE) RMVBLANK(*BOTH)[/FONT][/COLOR]
Comment