| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Accessing multiple database tables |
« View previous topic :: View next topic » |
| Author |
Message
|
| AgentSmith |
 Posted: Wed Feb 11, 2004 7:58 am Post subject: Accessing multiple database tables |
 |
|
Novice
Joined: 19 Nov 2003
Posts: 19
|
Hi,
SELECT statements with multiple table joins are giving a strange problem.. Kindly help me resolve this:
An ESQL statement like this:
| Code: |
SET Environment.Variables.SOURCE_DATA[]=(
SELECT
EVENT_SOURCE.SOURCE_ID,
SOURCE_SYSTEM_META_DATA.SYSTEM_NAME,
EVENT_SOURCE.LISTENER_COUNT
FROM
Database.SOURCE_SYSTEM_META_DATA,
Database.EVENT_SOURCE
WHERE
SOURCE_SYSTEM_META_DATA.SOURCE_ID = EVENT_SOURCE.SOURCE_ID
); |
gets converted to:
| Code: |
SELECT
EVENT_SOURCE.SOURCE_ID,
SOURCE_SYSTEM_META_DATA.SYSTEM_NAME,
EVENT_SOURCE.CHANGE_LOG_TABLE,
EVENT_SOURCE.CHANGE_LOG_PRIMARY_KEY_TABLE,
EVENT_SOURCE.TRANSACTION_STAGE_TABLE,
EVENT_SOURCE.LISTENER_DELAY,
EVENT_SOURCE.LISTENER_COUNT
FROM
SOURCE_SYSTEM_META_DATAEVENT_SOURCE --please note the concatenated table names
WHERE
(SOURCE_SYSTEM_META_DATA.SOURCE_ID)=(EVENT_SOURCE.SOURCE_ID) |
and throws an ODBC Exception.
I tried using Table Aliases (..
| Code: |
| Database.SOURCE_SYSTEM_META_DATA AS S, Database.EVENT_SOURCE AS ES |
..) but here also the table separator gets lost at runtime.
I'm using
"WebSphere Business Integration Message Brokers Version 5.0.1" (Fixpack 1);
Oracle 9i as Database;
MQSeries DataDirect 4.10 32-BIT Oracle8 ODBC Driver.
Regards,
Smith. |
|
| Back to top |
|
 |
| TonyD |
| Posted: Wed Feb 11, 2004 1:45 pm Post subject: |
|
|
Knight
Joined: 15 May 2001
Posts: 540
Location: New Zealand
|
| This is a bug.....fixed in CSD02 (where a lot of other things were also fixed so worth installing). |
|
| 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
|
|
|
|
