MQSeries.net :: View topic - ESQL 2.1.0 to ESQL 2.0.1

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 2.1.0 to ESQL 2.0.1

ESQL 2.1.0 to ESQL 2.0.1

« View previous topic :: View next topic »

Author

Message

sagwa99

Posted: Fri Oct 25, 2002 7:05 pm Post subject: ESQL 2.1.0 to ESQL 2.0.1

Novice

Joined: 14 Jun 2002
Posts: 15

I have ESQL statements in ver 2.1.0 and would like to convert them to ver 2.0.1.

DECLARE A INTEGER;

SET InputLocalEnvironment.Variables.Number[] = PASSTHRU('SELECT COUNT FROM TESTDB.DB2ADMIN.SUM');

SET A = InputLocalEnvironment.Variables.Number.SUM[0];

In 2.0.1 I have changed to:

DECLARE A INTEGER;

SET InputDestinationList.Variables.Number[] = PASSTHRU('SELECT COUNT FROM TESTDB.DB2ADMIN.SUM');

SET A = InputDestinationList.Variables.Number.SUM[0];

Well the error message - Cannot assigned to a symbolic constant or input message.

Thanks in advance for enlightment.

kirani

Posted: Sun Oct 27, 2002 11:14 am Post subject:

Jedi Knight

Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA

Try to use WKSPACE parser in MQSI 2.0.1
_________________
Kiran

IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries

tchagan

Posted: Mon Oct 28, 2002 5:35 am Post subject:

Apprentice

Joined: 10 Feb 2002
Posts: 31

Hi,

set aside some space inside the XML message that you are using for output.

i.e. if the message is called MyMessage do the following

set OutputRoot.XML.MyMessage.Variables.Number[] = PASSTHRU('SELECT COUNT FROM TESTDB.DB2ADMIN.SUM');

SET A = OutputRoot.XML.Variables.Number.SUM[0];

Only thing that you have to remember is to remove Variables from your output XML i.e.

set OutputRoot.XML.MyMessage.Variables = NULL;

or when you create your final output don't copy the Variables tag.

If you want to use the Variables tag in a later node, you would access it using :

InputBody.MyMessage.Variables.SUM[0]

etc.

Terry

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL 2.1.0 to ESQL 2.0.1

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