All Forums Database
sharib hussain 12 posts Joined 01/13
18 Nov 2015
Stored Procedure conditional handler for spool out error 2646

I want to implement a continue handler in the stored procedure for query that can spool out.

I check in pdcrinfo. SqlState_Codes there is no sqlstate associated to spool out error 2646. 

 

Query is in below form and it gets spooled out if values for  column are skewed.

INSERT INTO TAB1(col_value,row_count)

SEL COLUMNAME,COUNT(*) FROM TABLENAME GROUP BY 1

 

I intend to implement a continue handler so that in case of spool out procedure does’nt gets failed.

Thanks & Regards, Sharib Hussain
You must sign in to leave a comment.