IF condition in bteq

Database
Enthusiast

IF condition in bteq


Is the IF THEN ..END IF; syntax correct in Teradata? 



 


Tags (1)
4 REPLIES
Supporter

Re: IF condition in bteq


To unclear question!



In BTEQ it is 



IF THEN 



but only very view condtions are allowed.



 


Enthusiast

Re: IF condition in bteq

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

Regards,

Enthusiast

Re: IF condition in bteq

where can I find the complete list and examples of what is allowed and can be done within bteq.  Researching manuals now.  thanks, Mark

Enthusiast

Re: IF condition in bteq

Probably you can look into this manual...

http://www.teradataforum.com/teradata_pdf/b035-2414-062a.pdf