Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

BIND PLAN with two table with two different qualifiire??????

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vijayakumar.yellala

New User


Joined: 19 Apr 2006
Posts: 63
Location: Chennai

PostPosted: Fri Aug 20, 2010 4:21 pm    Post subject: BIND PLAN with two table with two different qualifiire??????
Reply with quote

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
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Fri Aug 20, 2010 4:33 pm    Post subject:
Reply with quote

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
View user's profile Send private message
vijayakumar.yellala

New User


Joined: 19 Apr 2006
Posts: 63
Location: Chennai

PostPosted: Tue Aug 24, 2010 4:00 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Aug 24, 2010 5:22 pm    Post subject:
Reply with quote

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
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Aug 24, 2010 6:54 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Aug 24, 2010 7:08 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Aug 24, 2010 8:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Aug 24, 2010 8:53 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us