Want to jump between different EXPORT operators or different SQL statements using variable
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 ).