View previous topic :: View next topic
|
Author |
Message |
vijayakumar.yellala
New User
Joined: 19 Apr 2006 Posts: 63 Location: Chennai
|
|
|
|
Hi,
I need to BIND PLAN with two table with two different qualifires.
Qualifier table name
DEV1DBUS ESHEMP_DATAT
MNS_SLS RDR_HS
Regards,
Vijay |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
I hope you mean bind package.
no can do
you'll have to qualify at least one of them in your program, preferably the one that doesn't have the environment in it. |
|
Back to top |
|
|
vijayakumar.yellala
New User
Joined: 19 Apr 2006 Posts: 63 Location: Chennai
|
|
|
|
no...
In the same program we have to use two tables, but the two table have two different qulifires.
So, Plz help me how to precompile the program with two qualifires.
Regads
Vjay |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
unless you are JOINing these two tables,
suggest you have a sub-module for each.
Then you have created a solution for anyone else
that encounters this absurd situation. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
dbzTHEdinosauer wrote: |
unless you are JOINing these two tables,
suggest you have a sub-module for each.
Then you have created a solution for anyone else
that encounters this absurd situation. |
absurd? We simply always qualify all tables in our programs, even when using one schema |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
GuyC,
qualifying tables is your experience.
In the 20 or so sites that I have worked,
I have never qualified the table in imbedded SQL.
always used the Bind parms to qualify the tables,
but, that did mean tables from differing schema required separate modules. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi,
We don't qualify tables too..
Aliases can be created to resolve this like,
Code: |
Database qualifier table
shandb shandb demployee
bobt1 bobt1 employee
Created the below alias,
CREATE ALIAS BOBT1.EMPSHAN
FOR SHANDB.DEMPLOYEE;
select * from bobt1.employee
where empno not in (select empno in bobt1.empshan);
|
Please let me know if my thinking is wrong....
Thanks,
Sushanth |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
Qualifying or not qualifying:it depends on your architecture, in both cases you have to live with the consequences. but neither is absurd. |
|
Back to top |
|
|
|