INSERTING EURO SYMBOL IN DB2



IBM's flagship relational database management system

INSERTING EURO SYMBOL IN DB2

Postby gauravfrankly » Fri Mar 11, 2016 11:52 am

Hi All,

I am having a stored procedure and using an XMLTABLE function to extract the values from Input XML.
We have EURO symbol (3BYTE) as the input in 1 tag, on executing the SP getting the SQLWARNING with SQLSTATE 01517. As we have DECLARE EXIT HANDLER FOR SQLWARNING, so SP is getting ABEND.
I have tried using DECLARE CONTINUE HANDLER FOR SQLSTATE 01517 it worked, but I have some restriction so can't use it in my code.
using DB2 10 z/os, DATBASE properties are like ENCODING_SCHEME = U and MIXED_CCSID = 1208
Could you please help us here , how we can get it resolved. to make the INSERT happen successfully.
gauravfrankly
 
Posts: 39
Joined: Fri Aug 07, 2015 3:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: INSERTING EURO SYMBOL IN DB2

 

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post