Help needed on Error handling in Teradata

Tools & Utilities
Highlighted
Enthusiast

Help needed on Error handling in Teradata

Hi All,

 

I am trying to do 'Bad data type' check inside our ETL framework (we predominantly use BTEQ scripts for the transformation logic). I am confused whether to do this error handling using BTEQ & Unix shell scripting or using TD Stored Procedures. Can you guys please chime in with your suggestions/advice.

 

Thanks,

Sundar

Tags (1)
2 REPLIES
Enthusiast

Re: Help needed on Error handling in Teradata

Can somebody guide me on this ? Waiting for your suggestions.

Teradata Employee

Re: Help needed on Error handling in Teradata

It's not clear what you are asking.

 

Perhaps the TRYCAST function (TD15.10 and later) could be part of the solution.