BTEQ :Multi user login for two tables

Tools
Enthusiast

BTEQ :Multi user login for two tables

Hi,

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
from
TDB1.Table1 A
Left Outer Join
TDB2.Table2 B
on A.contact=B.contact

please help me providing the correct inputs for BTeq utitlity.

even guidance to the correct thread will do.

Thanks!!!

2 REPLIES
Supporter

Re: BTEQ :Multi user login for two tables

No, one session is related to one user.

So you need to give the user the right to access both tables.

Enthusiast

Re: BTEQ :Multi user login for two tables

@ulrich, Thanks for the clarification.