Archives of the TeradataForum

Message Posted: Tue, 11 Mar 2008 @ 18:16:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The continue handler you have is for a Data Not Found situation. Try checking the SQLSTATE instead. SQLSTATE 42000 translates to SQLCODE 3807 which equates to Object does not exist.

     DECLARE CONTINUE HANDLER FOR SQLSTATE '42000'
                       CREATE GLOBAL TEMPORARY TABLE RENUM_CAND
                       (OLD_ACCT_ID CHAR(10) NOT NULL, NEW_ACCT_ID CHAR(10))
                       UNIQUE PRIMARY INDEX (OLD_ACCT_ID)
                       ON COMMIT PRESERVE ROWS;

Rob Bankston
Systems Consultant - Data Warehouse
Unum

	<Prev	Next>		<<First	<Prev	Next>	Last>>