setting a parameter inside of a bteq script

General
N/A

setting a parameter inside of a bteq script

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?

1 REPLY

Re: setting a parameter inside of a bteq script

In Unix/linux, you can use say for example : export DB_NAME=DB1 inside the script