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.
It's not clear what you are asking.
Perhaps the TRYCAST function (TD15.10 and later) could be part of the solution.