Conditinal Logic with dynamic parameteres in BTEQ.

Tools

Conditinal Logic with dynamic parameteres in BTEQ.

I have to get a value 0 or 1 from a query(dynamically) and want to write the conditional logic in BTEQ with the value i will get.How to handle this in UNIX?
Any assistance/examples would be appreciated.

1 REPLY
Enthusiast

Re: Conditinal Logic with dynamic parameteres in BTEQ.

since you just have a 0 or 1 check, you can re-write the query logic to return 0 or >0 rows and make use of the bteq variable ACTIVITYCOUNT along with bteq's if then control language to accomplish this.