sel date1 - date2 month(4) from table1 (sample query) When i execute a similar query in queryman it works fine but when i write a bteq and execute it using jcl it throws an ansi eror (operation cant be performed on a time interval value) how to solve it
> In BTEQ, is default mode ANSI or BTET?? --BTET is the default for BTEQ.
> for single statement request which one is best??? (regarding performance aspect) -- I am not sure if there is any performance gain for an 'exactly same' single statement. Using BTET mode, you will be able to use Teradata specific DMLs which otherwise may require string manipulation which is bad for performance.
> is thr any error tables like in FLoad and MLoad??
-- No. BTEQ doesnot support any error table. BTEQ supports limited conditional logic for system status values.User may change the severity level associated with one or more internal error code, then use it in conditional logic. A final return code other than 0 is either a warning or an error.