Re: Monitor for SQL error in ACS Run SQL Scripts

This will run without error when the table doesn't exist.

BEGIN
DECLARE not_found CONDITION FOR '02000';
DECLARE at_end *INTEGER* DEFAULT *0*;
DECLARE if_exists *INTEGER* DEFAULT *0*;
DECLARE CONTINUE HANDLER FOR *sqlexception* SET at_end = *1*;
DECLARE CONTINUE HANDLER FOR not_found SET at_end = *1*;
SELECT *
INTO if_exists
FROM server_name.schema_name.table_name;
END;

Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Cell: (416) 317-3144