MQSeries.net :: View topic - Common procedure call from a esql file question

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 » Common procedure call from a esql file question

Common procedure call from a esql file question

« View previous topic :: View next topic »

Author

Message

shediiwork

Posted: Mon Apr 16, 2007 7:14 am Post subject: Common procedure call from a esql file question

Acolyte

Joined: 07 Jun 2005
Posts: 52

I created a esql file with CopyMessageHeaders and wandering should the OutputRoot be IN or INOUT?

PATH COMMON;
CREATE COMPUTE MODULE MQSERIES_Question
CREATE FUNCTION main() RETURNS BOOLEAN
BEGIN
CALL CopyMessageHeaders(InputRoot, OutputRoot);
END
END MODULE;

<CopyMessageHeaders.esql>
BROKER SCHEMA COMMON

CREATE PROCEDURE CopyMessageHeaders(IN InputRoot REFERENCE, IN OutputRoot REFERENCE)
BEGIN
DECLARE I INTEGER 1;
DECLARE J INTEGER CARDINALITY(InputRoot.*[]);
WHILE I < J DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I = I + 1;
END WHILE;
END;

jefflowrey

Posted: Mon Apr 16, 2007 11:06 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

I guess it depends on if you intend to modify OutputRoot or not.
_________________
I am *not* the model of the modern major general.

vsr

Posted: Mon Apr 16, 2007 11:24 am Post subject:

Centurion

Joined: 04 Apr 2006
Posts: 104

This may be helpful:
http://www.mqseries.net/phpBB2/viewtopic.php?t=24036

jefflowrey

Posted: Mon Apr 16, 2007 11:39 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

vsr wrote:

This may be helpful:
http://www.mqseries.net/phpBB2/viewtopic.php?t=24036

Oh very nice! I learned something today.
_________________
I am *not* the model of the modern major general.

shediiwork

Posted: Mon Apr 16, 2007 11:57 am Post subject:

Acolyte

Joined: 07 Jun 2005
Posts: 52

Ahhhh, that was very helpful. I thought that INOUT was correct just wanted to pose the question to the forum.

Shed

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Common procedure call from a esql file question

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