My DB2 version is version 9.1 (Fix Pack 6 , 64 bits)。
When using GET DIAGNOSTICS EXCEPTION，I have a problem with garbled message。
My code is :
CREATE PROCEDURE SP_EXCP_B(OUT p_MSG VARCHAR(1000))
DECLARE EXIT HANDLER FOR SQLEXCEPTION
GET DIAGNOSTICS EXCEPTION 1 p_MSG = MESSAGE_TEXT;
INSERT INTO TEST(F_ID) VALUES(INTEGER('ABC'));
After calling the procedure, I found that the content of p_MSG is garbled message like
"SQL0420N b "INTEGER" rALrC SQLSTATE=22018 "
How could I solve the problem ? Thanks.
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2013-01-29T21:19:32Z by nivanov1
Pinned topic garbled message, when using GET DIAGNOSTICS EXCEPTION
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-29T21:19:32Z at 2013-01-29T21:19:32Z by nivanov1
nivanov1 100000H9H7231 Posts