All Forums Database
anjunair 13 posts Joined 04/12
13 Jul 2012
IF condition in bteq

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

 

Tags:
ulrich 816 posts Joined 09/09
13 Jul 2012

To unclear question!

In BTEQ it is 

IF THEN 

but only very view condtions are allowed.

 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Qaisar Kiani 337 posts Joined 11/05
15 Jul 2012

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,

mandre 6 posts Joined 07/10
23 Aug 2012

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

Qaisar Kiani 337 posts Joined 11/05
23 Aug 2012

Probably you can look into this manual...

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

You must sign in to leave a comment.