Page 1 of 1
SQLSTATE 01517
Posted: Tue Feb 16, 2010 5:40 am
by paritosh11
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
Posted: Tue Feb 16, 2010 6:33 am
by ArndW
What character set is the DB2 database stored in, and what NLS settings are you using in your job?
Posted: Tue Feb 16, 2010 6:40 am
by paritosh11
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
Posted: Tue Feb 16, 2010 7:57 am
by ArndW
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.
Posted: Wed Feb 17, 2010 3:31 am
by paritosh11
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
Posted: Wed Feb 17, 2010 4:04 am
by ray.wurlod
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.
Posted: Thu Mar 25, 2010 5:08 am
by sendmkpk
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.