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

Hi,
 
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;
.LOGOFF
.EXIT
 
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.