Questions tagged [bteq]

Is there a way to achieve If then computational logic using snowsql commands like we have in Teradata Bteq Commands as below: .if 1 >= 0 then select department_id from department; .if ACTIVITYCOUNT > 0 then select employee_id from employee

using bteq script, I want to delete the temporary error and log tables created during TPT load namely ErrorTable1, ErrorTable2, LogTable. I have prepared following bteq script with if-else, which will drop tables if it exists .LOGON…