All Forums Tools
cnaveen05 6 posts Joined 12/12
05 Dec 2012
How to Parameterize DATABASE name in BTEQ

I have a windows batch file calling a BTEQ statement as below :-
.RUN FILE C:\Teradata\BTEQ\Logon.txt;
select * from  DWTEST.CBI_NAV_TEST;
I want to parameterize the database name such that I dont have to hardcode the DB name explicitly something like this
select * from  &DWTEST.CBI_NAV_TEST;
Then at run time pass the parameter which would say &DWTEST = DWTEST so that the SQL executes without any issue. 
Please help me with this.

You must sign in to leave a comment.