Is the IF THEN ..END IF; syntax correct in Teradata?
To unclear question!
In BTEQ it is
but only very view condtions are allowed.
Yes, you can use the IF THEN statements for checking conditions.
e.g. below statement cheks whether the last SQL statement executed with/without error.
.IF ERRORCODE<> 0 THEN .QUIT
where can I find the complete list and examples of what is allowed and can be done within bteq. Researching manuals now. thanks, Mark
Probably you can look into this manual...