In a bteq script, can I set a variable in the begining of the script and then use it through out the sql statements in the bteq script?
for instance, in TSQL I can do something like....
DECLARE @state char(2)SET @state = 'UT'SELECT * FROM COLUMN = @state
can I do something like this in bteq?
In Unix/linux, you can use say for example : export DB_NAME=DB1 inside the script