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.
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.