Teradata Realtime Scenario Question

There is a scenario like the load should start after a particular table fetches a value else it should Bteq session should exit

there is a table A(flag_table) and main table B

No flag

table_a 1

Only when the Flag value is 1 in this table A, the main table B load should start else it should quit.


Answer

SELECT flag FROM table_a WHERE flag =1;

.IF ACTIVITYCOUNT = 0 THEN .GOTO .EXIT

so if the record is not found then activitycount will be zero and it ll exit the BTEQ