| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Multiple tables in a SELECT problem? |
« View previous topic :: View next topic » |
| Author |
Message
|
| TonyD |
 Posted: Sun Sep 28, 2003 11:55 pm Post subject: Multiple tables in a SELECT problem? |
 |
|
Knight
Joined: 15 May 2001
Posts: 540
Location: New Zealand
|
I'm using V5 and have coded:
| Code: |
SET Environment.Variables.Customer[] =
(Select A.CUSTID,
A.FIRSTNAME AS FIRSTNAME,
A. ......,
B.STREETNUMBER AS STREETNUMBER,
B. .......
from Database.bp234.CUSTOMER AS A,
Database.bp234.ADDRESS AS B
where A.SURNAME = InputRoot.MRM.MessageRequest.Surname;
|
However the execution fails with an SQL error saying:
| Quote: |
An unexpected token "." was found following "p234.CUSTOMER Abp234". Expected tokens may include: ",".
|
The original ESQL looks OK to me but it appears that the comma/space after 'AS A' has got lost somewhere in the internal reconstruction of the statement at execution time! Has anyone had a similar problem or is it something wrong that I have done? bp234.CUSTOMER and bp234.ADDRESS are valid tables and have been successfully accessed using other ESQL. |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Sep 29, 2003 8:57 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
I believe you may have found a bug in WBIMB V5.0! Have you tried using PASSTHRU function to do this?
If you have latest CSD installed then you can open a PMR for this problem.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| TonyD |
| Posted: Tue Oct 07, 2003 9:47 pm Post subject: |
|
|
Knight
Joined: 15 May 2001
Posts: 540
Location: New Zealand
|
| It was a bug...fixed in CSD02 (yet to be released). |
|
| 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
|
|
|
|
