CODEWITHSUNDEEP
sqlteradata
lightweight
lightweight

Reputation: 3327

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?

Upvotes: 0

Views: 2782

Answers (1)

Ispirer SQLWays Migrations
Ispirer SQLWays Migrations

Reputation: 1058

I guess you can use environment variables like ${state} in shell scripts before calling the bteq script.

Upvotes: 1

Related Questions