SQLSTATE 01517

paritosh11 · Post by **paritosh11** » Tue Feb 16, 2010 5:40 am

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 Column2 is a VARCHAR(50) extended unicode containing Korean characters.

I have checked for NULL in the table bt there is none..also used trim functions ...etc.

This warning can be ignored bt i need a reason it is coming and how to remove it.

Thank in advance.
paritosh

ArndW · Post by **ArndW** » Tue Feb 16, 2010 6:33 am

What character set is the DB2 database stored in, and what NLS settings are you using in your job?

paritosh11 · Post by **paritosh11** » Tue Feb 16, 2010 6:40 am

ArndW wrote: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 on this.

Thanks in Advance.
paritosh

ArndW · Post by **ArndW** » Tue Feb 16, 2010 7:57 am

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 error.

paritosh11 · Post by **paritosh11** » Wed Feb 17, 2010 3:31 am

ArndW wrote: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
Database country/region code = 1

now can u give me some idea what all i need to chage. As NLS setting in DB2 stage as i metioned before is Job default UTF -8.

Thank You,
Paritosh

ray.wurlod · Post by **ray.wurlod** » Wed Feb 17, 2010 4:04 am

I doubt that U can help - he's working on an all-Oracle site.

The second person personal pronoun in English is spelled "you".

You might like to perform an internet search for the SQLSTATE value.

sendmkpk · Post by **sendmkpk** » Thu Mar 25, 2010 5:08 am

hi,
i am facing the same problem. but it is chinese, here.
In DB2 it is VARCHAR(255)
and in my stage NLS setting is Job default (UTF-8).

I have also tried changing the NLS setting to IBM-1386_P100_2002, UTF-16, result is same.
i tried doubling tripling length,

can some one, give his/her valuable insight into this.