BTEQ- Assign Value to User Defined Variable

UDA

BTEQ- Assign Value to User Defined Variable

Hi All,

I am pretty much new to teradata. I need help from all of you.

I have a situation where i need to pass date parameters in dos for BTEQ

In BTEQ i have a condition WHERE CUST_REV.Bill_Cyc_Date BETWEEN DATE and

when i run my bteq script in DOS It should prompt for dates.

can any one helps me how to acheive this
1 REPLY
Enthusiast

Re: BTEQ- Assign Value to User Defined Variable

There is no way u can make BTEQ prompt for a value.U need to program a front end and pass the parameter values to the embeded BTEQ in that program.