Hi, i have a bteq which uses repeat function to load a file into a table. we have a parameter for the input file. if the parameter is not available, the script is failing with a Return code 0, inspite of using the label to exit if errorcode <>0.

Hi ,
After this DECLARE EXIT HANDLER FOR SQLEXCEPTION , i need to update a table and insert a value into another table . How can i accomplish this ? Pls help .

Hi all,
I have a scenario where i have to CAST most of the columns and create and create a view.
Now the issue i am having is some CASTS fail because of bad format in data. In this case i have to put all failed values as NULL.
becaus of this i am writing a custom code everywhere based on the context.

Hello,

I am using a CONTINUE HANDLER as part of my stored procedure to manage Dropping of Indexes.

I do not want the SP to error out becuase an Index doesn't exist as I am just wanting to drop it any way.

The CONTINUE HANDLER does just fine if there is 1 index missing if there are multiple then the handler is no longer managing the process and the SP errors out with a message of 'Index doesn't exist'

DECLARE CONTINUE HANDLER FOR SQLSTATE VALUE '52004'
DDLERROR: BEGIN
INSERT INTO NSBI_TDB.ETL_DEBUG VALUES(CURRENT_TIMESTAMP(0), c_PROC_NM, 'INDEX0 DROP',SQLSTATE);