One of the columns in the table contains Japanese characters, and I can see them in Control Center and Command Editor, however, I can't get them into an exported file.
If I use the export function in Command Editor, the resulting file just has hex 3F where the DBCS chars should be, one per character. I've also tried simple queries from a command window, and those just contain -> (single right arrows).
Is there any way to generate a UTF-8 compliant output file?
C:\DB2> db2 export to test.csv of del select * from testdb.testtb
SQL3104N The Export utility is beginning to export data to file "test.csv".
SQL3105N The Export utility has finished exporting "1" rows.
C:\DB2> notepad test.csv
it actually has 5 arrows with this -> between the quote marks.
notepad has it's font set to MS PMincho with Japanese script set.
I had also run
in the CLP session prior to the above test
I then tried "of del modified by codepage=1208 ...." and it worked as I expected.