| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Namespace prefixes used with Passthru |
« View previous topic :: View next topic » |
| Author |
Message
|
| pottas |
 Posted: Tue Jul 14, 2009 8:27 am Post subject: Namespace prefixes used with Passthru |
 |
|
Disciple
Joined: 27 Oct 2005
Posts: 185
Location: South Africa
|
Guys,
I am running WMB 6.1 Toolkit Build id: 6.1.0.3-IFix003-20090305_1223, and WMB 6.1.0.3 on a Windows XP platform.
I have the following challenge regarding namespaces.
I do a database select using a passthru right into my Soap message (obviously for perfomance reasons):
| Code: |
| SET OutputRoot.XMLNSC.ns:Envelope.ns:Body.crd:PostalCodeEnqRs.crd:PostalCodeList.crd:PostalCodeItem[] = PASSTHRU('SELECT substr(A.TOWN_NAME,1,20) as "City" FROM PCD.PCD_01620 AS A WHERE A.STR_BOX_DELVERY = ? ORDER BY A.PRIMARY_POST, A.TIE_BREAK ASC FETCH FIRST 100 ROWS ONLY' TO Database.PCDD01DB VALUES (strOrBox)) |
But the resulting message fails the WSDL validation, simply because it *wants* a namespace prefix as part of the 'City' field selected from the database.
Example:
| Code: |
| SET OutputRoot.XMLNSC.ns:Envelope.ns:Body.crd:PostalCodeEnqRs.crd:PostalCodeList.crd:PostalCodeItem[] = PASSTHRU('SELECT substr(A.TOWN_NAME,1,20) as "NS2:City" FROM PCD.PCD_01620 AS A WHERE A.STR_BOX_DELVERY = ? ORDER BY A.PRIMARY_POST, A.TIE_BREAK ASC FETCH FIRST 100 ROWS ONLY' TO Database.PCDD01DB VALUES (strOrBox)) |
...this seems to work...
So, how do I get past this? how do I get the resultset to have the correct namespace prefix without hard-coding it as part of the passthru select?
Thanks in advance
Jacques |
|
| 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
|
|
|
|
