Could you please help me with the following query? i googled but couldn't get much help regarding this topic.
current syntax that we use:
cat TEST.sql | cat loginfile > BTEQ;
the sql file contains queries like
select * from TDB1.TABLE1;
Now, i wish to access two tables. but both tables cannot be accessed with same login as a security measure. Is it possible to give two login files for the BTEQ query???
TDB1 is accessible using "user1" ID. and TDB2 us accessible using "user2" ID.
consider the query.
select A.contact, B.names
Left Outer Join
please help me providing the correct inputs for BTeq utitlity.
even guidance to the correct thread will do.