MQSeries.net :: View topic - How to find the position of '

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 » How to find the position of '

How to find the position of '

« View previous topic :: View next topic »

Author

Message

WBI_user

Posted: Wed Dec 19, 2001 9:43 pm Post subject:

Partisan

Joined: 07 Aug 2001
Posts: 386

I need to find the position of ' in a field. I tried
DECLARE P INTEGER;
SET P=POSITION(''' IN MESSAGE};
This gives me a syntax error.
I tried
SET P=POSITION("'" IN MESSAGE); with no luck

Please help .

NickB

Posted: Thu Dec 20, 2001 2:20 am Post subject:

Centurion

Joined: 20 May 2001
Posts: 107
Location: Zurich Financial Services

Kelvin

Whilst the editor gives you a syntax error, you can successfully deploy this eSQL and it WILL work correctly.

NickB

Posted: Thu Dec 20, 2001 2:22 am Post subject:

Centurion

Joined: 20 May 2001
Posts: 107
Location: Zurich Financial Services

Oops, meant to include a couple of samples:

a) SET I = POSITION('''' IN InputRoot.XML.DATA);

b) DECLARE X CHARACTER;
SET X='''';
SET I = POSITION(X IN InputRoot.XML.DATA);

Both of these examples work fine in MQSI 2.0.2

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to find the position of '

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