Want to jump between different EXPORT operators or different SQL statements using variable

Tools
Teradata Employee

Want to jump between different EXPORT operators or different SQL statements using variable

Hi,

I am building an TPT which is doing fast load(LOAD operator) to a NAV_REP table.

I am using export operator to export the data . Now I have two sql statements. one statement is doing calculation based on year and second statement is doing calculation based on month.

I want to pass a variable like CALC = 'M' or CALC = 'Y' and based on that variable, I want to choose the SQL statement in EXPORT . If I pass CALC = M then EXPORT operator should choose SQL statement 1 which is doing calculation based on Month and if  CALC = Y then EXPORT operator should choose SQL statement 2 which is doing calculation based on Year.

KIndly note that both the SQLS have exactly same format of out put so there is no need to different schema.(I am using TD 13.10 ).

How can I do that?

Thanks and Regards,

Ram

Tags (1)