| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Access Oracle or DB2 Depending on where the flow is deployed |
« View previous topic :: View next topic » |
| Author |
Message
|
| pawargmat |
 Posted: Tue May 03, 2005 8:03 am Post subject: Access Oracle or DB2 Depending on where the flow is deployed |
 |
|
Novice
Joined: 13 Feb 2004
Posts: 14
|
Hi,
I want to know if it is possible to check within ESQL(compute node) whether we are accessing Oracle of DB2 database.?
We use Passthrus to make Database calls. So I want to know if it is possible write something like
If database is DB2 construct sql this way or if it is Oracle construct sql in another way!.. later make a call using Passthru (sql, parameters)..
Thanks,
pg. |
|
| Back to top |
|
 |
| JT |
| Posted: Tue May 03, 2005 11:06 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Can you clarify the need for developing this code? Does the database platform change as the code migrates through the various environments?
Ultimately the database platform of the data source, defined to the Compute node, is resolved through the ODBC configuration. AFAIK, there's now way programmatically for you to derive that information.
Perhaps you can encapsulate the platform-specific SQL calls within stored-procedures, and then invoke those stored-procedures from the ESQL code, regardless of the database platform. By creating a common name for the stored-procedure, the need to determine the database platform is eliminated. |
|
| Back to top |
|
|
| pawargmat |
| Posted: Thu May 05, 2005 2:21 am Post subject: |
|
|
Novice
Joined: 13 Feb 2004
Posts: 14
|
Hi,
Thanks for the reply.
The need : Flows access local Oracle database. If for some reason the local Oracle database cannot be accessed, there is a need to access central Mainframe DB2 database. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu May 05, 2005 3:06 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| Code: |
Try/Catch -- try --> ComputeNode (Oracle)-- -->
-- catch --> ComputeNode (DB2) --| |
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
