| Author |
Message
|
| TonyD |
 Posted: Sat Feb 21, 2004 8:12 pm Post subject: XML Element Names in ESQL |
 |
|
Knight
Joined: 15 May 2001
Posts: 540
Location: New Zealand
|
In WMQI 2.1, when XML elements have been defined in message sets, the fully qualified names appear in the ESQL panel when the elements are accessed using Compute node 'drag and drop', for example:
| Code: |
InputBody".(XML.Element)"GROUP"."POLICY"."INSUREDPARTIES"."POSTALADDRESS"."AddressLine2"
|
This was a useful way to get the correct names into the ESQL work area.
Unfortunately the WBI Mapping node does not provide the same facility and it is therefore necessary to enter the qualified names, with risk of error, in subsequent Compute nodes The Mapping node ESQL is generated with qualified names, and can be seen in a service trace, but does not appear to be available anywhere(althoughI have suggested to IBM Support that it would be useful if this could be externalised in the future).
We have imported some fairly involved XML schema into the workbench which we need to reference with ESQL. Is there any way of displaying the fully qualified name of a lower level element, either within the workbench or using another tool? |
|
| Back to top |
|
 |
| TonyD |
| Posted: Sun Feb 22, 2004 7:50 pm Post subject: |
|
|
Knight
Joined: 15 May 2001
Posts: 540
Location: New Zealand
|
Found the answer:
<WBI-PATH>eclipse\workspace\.metadata\.plugins\com.ibm.etools.mft.esql\MyFlowProject\MyFlowName_Mapping.mfmap.schemaRoutines |
|
| Back to top |
|
|
| wooda |
| Posted: Mon Feb 23, 2004 1:23 am Post subject: |
|
|
Master
Joined: 21 Nov 2003
Posts: 265
Location: UK
|
| WBI also has code assist in the Compute node ESQL editor. This allows you the flexibility to hand write ESQL but still make sure you are using correct element path names. Warnings will also be thrown if the code assist find references that cannot be resolved to fields in your message set. |
|
| Back to top |
|
|
| TonyD |
| Posted: Mon Feb 23, 2004 2:52 pm Post subject: |
|
|
Knight
Joined: 15 May 2001
Posts: 540
Location: New Zealand
|
| I am aware of Content Assist but how do I make it aware of the element names in the Message Sets that have project references from the Message Flow project where I am coding the ESQL? |
|
| Back to top |
|
|
| wooda |
| Posted: Tue Feb 24, 2004 2:55 am Post subject: |
|
|
Master
Joined: 21 Nov 2003
Posts: 265
Location: UK
|
This works fine for me in v5.
I added the project reference from the flow project to the set project.
I rebuilt by flow project.
Then the ESQL editor presents me with a list of possible element names at each level.
They appear to correctly match those found in the message set project(s) referenced in my message flow project.
The only problem I can see is that it does not resolve elements under an open-defined type.
And it sometimes give a warning that an element cannot be resolved (even though code assist was used to build the path in ESQL.) But as it's only a warning it is just annoying and doesn't stop anything working. |
|
| Back to top |
|
|
| wooda |
| Posted: Tue Feb 24, 2004 2:58 am Post subject: |
|
|
Master
Joined: 21 Nov 2003
Posts: 265
Location: UK
|
| By the way I have WBIMB V5 CSD02 installed. I've no idea if this worked before this level. |
|
| Back to top |
|
|
| TonyD |
| Posted: Tue Feb 24, 2004 3:56 pm Post subject: |
|
|
Knight
Joined: 15 May 2001
Posts: 540
Location: New Zealand
|
| You're right! Don't know why it was not working for me before....possibly doing a Project Rebuild sorted it out. Anyway, thanks for the help. |
|
| Back to top |
|
|
|
|
