I use the following statement to extract from DB to a text file(ascii format):

db2 -x -tf ${TMP_SCRIPT_NAME} -r ${OUTPUT_FILE_DIR}/${OUTPUT_FILE_NAME}.${OUTPUT_FILE_EXT} > /dev/null 2>&1

Are there any options that I could use on the above statament to be able to extract the data to a text file (UTF-8) format ?

Please advice. Thank.s

Complex read:
http://www-106.ibm.com/developerwork...u/0210lau.htm;
http://www-106.ibm.com/developerwork...0209kline.html

If your database is in UTF-8, you can use the "codepage=1208" modifier in the EXPORT command.

The source database is not UTF-8. Is there any possibility to modify the statement mentioned earlier to achieve the output in UTF-8 format ?

As Nick already said, you can use the EXPORT command and the "codepage" modifier.