MQSeries.net :: View topic - Syntax in Mapping editor

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Syntax in Mapping editor

Syntax in Mapping editor

« View previous topic :: View next topic »

Author

Message

PisgahMan

Posted: Mon Sep 17, 2007 8:50 am Post subject: Syntax in Mapping editor

Voyager

Joined: 27 Jul 2004
Posts: 93

v6.

I am using a message map to pull data from a database and populate an XML message. I have a where clause in the db$:select row of the message editor.

This works fine with a hardcoded value:

Code:

$db:select.d1aor1.DEV1BR1.BR_WK_ITM.BR_SVC_REQ_ID="1226888"

What I would like to do is use a field in the Message, which is part of the source in the mapping editor as the where clause.

This does not work

Code:

$db:select.d1aor1.DEV1BR1.BR_WK_ITM.BR_SVC_REQ_ID=$source/CONFIRM/CONFIRM_DetailRecord/TransactionControlNumber

What am I doing wrong?

The error I get is
[Microsoft][ODBC Driver Manager] Driver does not support this function.

SET SELECT_RESULT1#.selectResultRef_0[ ] = (SELECT COLUMN(0) AS :BR_SVC_REQ_ID, COLUMN(1) AS :BR_WK_ITM_ID FROM DATABASE(, source_body.HeaderRecord.RecordType));

i am guessing that no value is being passed or inserted into the SQL Where clause.

Any help appreciated.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Syntax in Mapping editor

Jump to:

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

Protected by Anti-Spam ACP