DSXchange

Ask your DB2 administrator what character set the database is defined in. Make sure that setting is identical to what you specify in DataStage for the DB2 stage; that is probably the cause of your err ... Hi, This are the setting at DB2 Database. Database code page = 1208 Database code set = UTF-8 ...

What character set is the DB2 database stored in, and what NLS settings are you using in your job? ... In DB2 it is VARCHAR(50) and in my stage NLS setting is Job default (UTF-8). I have also tried changing the NLS setting to ASCL_KSC5601 bt the result is same. let me know if you need any more info...

Hi, I am getting below warning message in my parallel job in a DB2/UDB stage. SQLSTATE 01517: A character that could not be converted was replaced with a substitute character. Where im using a select query of the form. SELECT A.Column1, A.Column2 FROM staging_table A WHERE some condition In here Col...

Thanks for the reply... In dev and stage we are using the q pasa. In Q pasa we are typing the message. In test if we do and enter for new line, the result file is having the "^M". But this is happening only in test See I dnt know much abt Q pasa ....but all i can see here is that its not ...

Hi... We have a requirement to read messages and process the file. The message we are reading is text file. Some times we are getting "^M" at the end of the line. We are using q pasa to put the message. In dev environment we were not facing this issue. But in test environment the "^M...