November 04, 2010, 09:56 AM
jbanas6executing Teradata Macro issue
i need advice and/or ideas on how to perform some code that works fine without ABORT statements in a teradata macro but when the ABORT statements go into the macro it fails on the 1st item i am printing out. We had this working fine and it returns data when the ABORT statements are out of the macro; However IT would like us to add a couple of ABORT statements to error trap.
This statement is causing errors in webfocus, access and excel:
ABORT 'ID_NBR Must be 10 digits (with no leading or trailing spaces) when searching for the BOND_ACCT_NBR'
WHERE :ID_TY = 'BOND'
AND character_length ( trim (:ID_NBR) ) <> 10;
does anyone have a work around for this? or experienced this