<div>
Thanks for response..<br />
<br />
I got the clue that i need to create a error table.<br />
I have declared the SQLCODE and SQLSTATE variables.<br />
<br />
i have added following to my code.<br />
DECLARE EXIT HANDLER FOR SQLEXCEPTION<br />
&nbsp; &nbsp; SET SQLSTATEOUT = SQLSTATE;<br />
<br />
DO i need to add the insert into error_code table in with in handler block?<br />
How to move the control to &quot;insert into error_code table&quot; statement.<br />
<br />
Pls let me know
</div>


Thanks for response..

I got the clue that i need to create a error table.
I have declared the SQLCODE and SQLSTATE variables.

i have added following to my code.
DECLARE EXIT HANDLER FOR SQLEXCEPTION
    SET SQLSTATEOUT = SQLSTATE;

DO i need to add the insert into error_code table in with in handler block?
How to move the control to "insert into error_code table" statement.

Pls let me know

<div>
Question abandoned<br />
Provided solution
</div>


<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
Please let me know &quot;How to Print SQLCODE and SQLSTATE info in the Procedure output when procedure fails<br />
to process some input records.<br />
<br />
So that i can understand the problem of issue.<br />
<br />
Thanks in advance!!!
</div>
</div>


Hi All

Please let me know "How to Print SQLCODE and SQLSTATE info in the Procedure output when procedure fails
to process some input records.

So that i can understand the problem of issue.

Thanks in advance!!!

How to Print SQLCODE and SQLSTATE info in the Procedure output in DB2 LUW 10.5

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.