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
 

 

Single package bind with two different DB2 Databases

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vinit_infy
Warnings : 1

New User


Joined: 07 Apr 2005
Posts: 56

PostPosted: Tue Jul 19, 2011 5:36 am    Post subject: Single package bind with two different DB2 Databases
Reply with quote

Hi,
I have a requirement where i need to write one cobol db2 program which need to access two different db2 databases on two different DB2 sub system.
That means, i have 2 select sql queries in a single cobol program to read 2 different tables lying in 2 different databses.

Can anybody tell me if it will create any issue during bind? Since, i will have one package i am not sure if it is possible to bind one single package accessing 2 different tables in 2 different databses. I need you expert thoughts on this as quick as possible.

Thanks
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jul 19, 2011 9:03 am    Post subject:
Reply with quote

Hello,

Suggest you do nothing until you talk with your dba and/or other database support people. Many (Most) organizations will not even entertain the concept. . . Maybe yours will.

Also suggest you consider extracting the needed data from one subsystem and then using this extracted (sequential) data to "drive" a process to read the other
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Tue Jul 19, 2011 9:56 am    Post subject: Reply to: Single package bind with two different DB2 Databas
Reply with quote

Quote:
I need you expert thoughts on this as quick as possible.


since we reply on voluntary basis and free of charge,
we do not do as quick as possible, we reply when and if we feel like,
if You/Your organization have time constraints the best thing to do is hire a paid consultant icon_evil.gif

as far as accessing two different DB2 subsystems the answer is the same as the one You got for Your oracle topic,
DRDA
but it looks like You did not care to read and understand the replies given to You!

Quote:
Can anybody tell me if it will create any issue during bind?

why should it ?

the manuals have all the info and the examples needed to implement it,
nothing overly complicated, but not very quick either!

but your support will have to setup the proper infrastructure


BUT ...
Quote:
I have a requirement where i need to write one cobol db2 program which need to access two different db2 databases on two different DB2 sub system.


that' s what I find disturbing, in these organization managed by incompetents , the poor planning,
it is not enough to tell a programmer what tables to use,
some idiot should have cared beforehand to plan for the proper setup
and not put the whole load on the last unfortunate wheel of the carriage icon_biggrin.gif
Back to top
View user's profile Send private message
vinit_infy
Warnings : 1

New User


Joined: 07 Apr 2005
Posts: 56

PostPosted: Tue Jul 19, 2011 5:51 pm    Post subject:
Reply with quote

Thank enrico, i just requested if someone can help me asap. nothing else.

Oracle is now out of picture, because i got dump in db2 tables itself but the database is different. Anyways thanks for your comments.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jul 20, 2011 9:07 am    Post subject:
Reply with quote

Hello,

Quote:
i just requested if someone can help me asap. nothing else.
You have been here 6 years and seen many topics & replies.

Whi might you believe it appropriate to request anything asap icon_sad.gif

If you really need something in a hurry, hire someone who can provide the answer immediately. Your sense of urgency is not shared by anyone here. . .
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 JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts Converting multiple VB files to FB fi... Viswanath Reddy JCL & VSAM 6 Mon Aug 08, 2016 11:49 pm
No new posts Single step utility for compare and u... ramprakashn JCL & VSAM 5 Fri Apr 29, 2016 3:43 pm


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