If the source of the data is DB2 and the DB2 is version 8 you can convert the data to unicode in the unload.
It does require that you modify the SQL and replace every character column as CAST (STMT AS CHAR (16) CCSID UNICODE) You have to set the length field correctly If you want to convert your numeric fields to unicode characters, it would be CAST (CHAR(NUMBER ) AS CHAR (10) CCSID UNICODE) modify the length field again Mike
PUT 'DBXP.SDB2P.PARTTAB.UNLOAD' test.part.unicode.txt
-- Mike ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
