How to Parameterize DATABASE name in BTEQ

Tools & Utilities
Enthusiast

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.

Tags (1)