| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| problem in running the comple SQL query in message flow. |
« View previous topic :: View next topic » |
| Author |
Message
|
| know_ashu |
 Posted: Mon Aug 29, 2005 4:40 am Post subject: problem in running the comple SQL query in message flow. |
 |
|
Novice
Joined: 25 Jun 2005
Posts: 22
|
Hi,
I am using WMQI2.1 and have complex query to run in a compute node.
Problem is coming because of single quotes while using PASSTHRU.
Please note that I need to use UNION, SUBSTR, DISTINCT key words in my query.
***************************************
DECLARE QUERY CHARACTER;
SET QUERY = 'select DISTINCT t1.a, t2.b, t2.c from user1.table_a as a, user1.table_b as b where a.c = 'abc' and b.d = 'pqr' and a.c1 = ? and b.c1 = ?
UNION
Select DISTINCT t3.c, t4.d, ' ' from user1.table_c as c, user1.table_d as d where SUBSTR(c.c1,12,2) = 'ABC' and d.c2 = ?';
SET OutputRoot.XML.Data[] = PASSTHRU(QUERY, Environment.Variable.a, Environment.Variable.b, Environment.Variable.c);
****************************************
This compute node contains only these above lines...and giving error.
Kindly help... |
|
| Back to top |
|
 |
| wschutz |
| Posted: Mon Aug 29, 2005 5:50 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
produces he'was' into X
(from the documentation)
_________________
-wayne |
|
| 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
|
|
|
|
