Create a nested IF loop in Teradata BTEQ without Procedures or Cursors ?

Database

Create a nested IF loop in Teradata BTEQ without Procedures or Cursors ?

How to create a nested IF loop in Teradata BTEQ without Procedures or Cursors ? I know, one way is to use Case..When statement.
1 REPLY
Enthusiast

Re: Create a nested IF loop in Teradata BTEQ without Procedures or Cursors ?

If you really want to do it in BTEQ as opposed to SQL, you can't use the CASE statement. You can only do it with the ".IF" and ".GOTO" statements.

If you have an example of what you're trying to do, maybe you'll get some better advice.