You can do this by creating a character conversion table and then specifying it on the FTP command:
a) Get a copy of the QASCII (EBCDIC to ASCII) conversion table by using the RTVTBLSRC command:
RTVTBLSRC TBL(QASCII) SRCFILE(my_lib/QTXTSRC) SRCMBR(MYQASCII)
b) Use SEU (or WDSC) to edit the MYQASCII source member you just created. Line 3.00 of the source member should be changed to begin “2020” instead of “20A0″.
c) Save the source member and then create your new table using the CRTTBL command:
CRTTBL TBL(QGPL/MYQASCII) SRCFILE(*LIBL/QTXTSRC)
7) When using FTP, add the parameter TBLFTPOUT and specify your new conversion table:
FTP RMTSYS(‘192.168.0.1′) TBLFTPOUT(QGPL/MYQASCII)
Hope it helps
Note that you only want to use a translation table against character fields. A hex-41 byte can appear in non-character areas of a record and those <i>should not</i> be translated.
<pre>UPDATE myfile SET mycol = replace( mycol ,x’41’,x’40’)</pre>You should be able to run that against any table MYFILE for any column MYCOL. If you create it as a QM query, you can place substitution variables for the table and column names.