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.