How to execute multiple macros in single statment.

Database
Enthusiast

How to execute multiple macros in single statment.

Hi,

I have 3 macros. if  col= 3 then execute first macro(Abc)

                                if col=8 then execute second macro

                          else execute third macro.

Thanks

Anil

2 REPLIES
Highlighted
Teradata Employee

Re: How to execute multiple macros in single statment.

You can have conditional logic [IF or CASE] either in SP or BTEQ script. For your scenario BTEQ script would be the workable option.

Enthusiast

Re: How to execute multiple macros in single statment.

Thanks Adeel,

My req is convert sp in to Macros. I have splited in to 3 macros. I need to execute All three macros in single statement.

For example :

If col= 'A '  then execute first macro

 if col = 'B' then execute second macro

else  col='c' then exeecute third macro.

Thanks

Anil