MQSeries.net :: View topic

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 » ESQL Compare

ESQL Compare

« View previous topic :: View next topic »

Author

Message

dkiu

Posted: Fri Apr 05, 2013 9:23 pm Post subject: ESQL Compare

Apprentice

Joined: 28 Feb 2013
Posts: 25

Hello,

Can anyone help in identifying the difference between below given 2 ESQL statements :-

1) DECLARE refToInvoice TO REFERENCE "InputRoot"."XMLNSC"."SaleEnvelope"."SaleList"."Invoice";

2) DECLARE refToInvoice REFERENCE TO InputRoot.XMLNSC.SaleEnvelope.SaleList.Invoice;

I do not find any difference in the message tree structure after removing " " symbol but just want to know if there is any specific use placing double quotes ?

adubya

Posted: Fri Apr 05, 2013 11:57 pm Post subject:

Partisan

Joined: 25 Aug 2011
Posts: 377
Location: GU12, UK

They are equivalent and will give the same result. Use quotes around element names if they clash with ESQL keywords or contain reserved characters etc. The name in quotes will then be taken literally.

e.g

InputRoot.XMLNSC."top.level"."field"

top.level is a legitimate element name but if left unquoted then the ESQL parser couldn't differentiate between a single element named top.level or a hierarchy of a parent element named top with a child named level.

dkiu

Posted: Sat Apr 06, 2013 1:36 am Post subject:

Apprentice

Joined: 28 Feb 2013
Posts: 25

Thanks for confirming my understanding

Vitor

Posted: Sun Apr 07, 2013 10:37 am Post subject:

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

Note that there's a performance cost to using "" like this.

Unless it's unavoidable (like you have a tag name that's a reserved word) don't do it.

Note that you only need to quote those elements that need it:

Code:

InputRoot.XMLNSC.SaleEnvelope.Sale."Contains".InvoiceLine

This is perfectly legal.
_________________
Honesty is the best policy.
Insanity is the best defence.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL Compare

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