| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| using passthru with where clause |
« View previous topic :: View next topic » |
| Author |
Message
|
| sudeepm |
 Posted: Mon Mar 17, 2008 9:19 pm Post subject: using passthru with where clause |
 |
|
Acolyte
Joined: 31 Jan 2008
Posts: 57
|
Hi all,
there have been numerous posts on using passthru,but didnt actually find anything to help....
i am using passthru for a database query having a where clause,the problem is that the where clause is applied on a field of character type,my statement is:
| Code: |
| statement = "SET OutputRoot.XML.Result[] = PASSTHRU('SELECT REPLAY_FLAG FROM DB2ADMIN.REP_TABLE WHERE REPLAY_FLAG = \'true\' ')"; |
this is what i get when i try creating an MbSQLStatement object using the above statement string:
| Quote: |
| (com.ibm.broker.plugin.MbRecoverableException) <com.ibm.broker.plugin.MbRecoverableException class:JNI method:SqlParser::functionCallExpression source:BIPv600 key:2401 > |
wasnt able to get any more details abt the exception,though i am sure this is coming because of the using the \(escape) character to put ' ' around the value "true" . i remove the where clause and the error is gone!!
please help me with this! |
|
| Back to top |
|
 |
| sudeepm |
| Posted: Mon Mar 17, 2008 9:36 pm Post subject: |
|
|
Acolyte
Joined: 31 Jan 2008
Posts: 57
|
okay,problem solved using parameters.the statement goes this way:
statement = "SET OutputRoot.XML.Result[] = PASSTHRU('SELECT REPLAY_FLAG FROM DB2ADMIN.REP_TABLE WHERE REPLAY_FLAG = ? ','true')"
might help someone else like mine  |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Mar 18, 2008 2:33 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Nobody should do this, because nobody should use XML domain, only XMLNS or XMLNSC.
_________________
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
|
|
|
|
