View previous topic :: View next topic
|
Author |
Message |
vinit_infy Warnings : 1 New User
Joined: 07 Apr 2005 Posts: 56
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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
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 |
|
Back to top |
|
|
vinit_infy Warnings : 1 New User
Joined: 07 Apr 2005 Posts: 56
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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
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 |
|
|
|