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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.