Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     executing Teradata Macro issue
Go
New
Search
Notify
Tools
Reply
  
executing Teradata Macro issue
 Login/Join
 
Gold member
posted
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


WF 7.6.10 /IIS 6/ JBoss Enterprise 4.3
Windows XP SP 2/Windows 2003 Server
MVS 7.3.3
 
Posts: 76 | Location: Hartford, CT | Registered: August 30, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     executing Teradata Macro issue

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.