MQSeries.net :: View topic - Is there Array datatype in esql?

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 » Is there Array datatype in esql?

Is there Array datatype in esql?

« View previous topic :: View next topic »

Author

Message

jeevan

Posted: Thu Oct 05, 2006 9:59 am Post subject: Is there Array datatype in esql?

Grand Master

Joined: 12 Nov 2005
Posts: 1432

need to perform the following.

SET consseq_array[*] = PASSTHRU ('SELECT Nextval FOR CONSSEQ FROM CONSUMER');
SET consseq = consseq_array[1];
-- set consseq = PASSTHRU ('SELECT Nextval FOR CONSSEQ FROM CONSUMER');
SET acctseq_array[] = PASSTHRU ('SELECT Nextval FOR ACCTSEQ FROM ACCOUNT'); SET acctseq = acctseq_array[1];
-- set acctseq = PASSTHRU ('SELECT Nextval FOR ACCTSEQ FROM ACCOUNT');
SET acctseq = acctseq_array[1];

when I run this, it gives error in all arrays variable. Can not array be implemented in Esql?

thanks

madi

Posted: Thu Oct 05, 2006 10:03 am Post subject:

Chevalier

Joined: 17 Jan 2006
Posts: 475

u can use ROW

--madi

jefflowrey

Posted: Thu Oct 05, 2006 10:07 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

It's not an array.

It's a logical tree, where siblings of an element can be accessed by index.

And you don't want to say consseq_array[*].

You want consseq_array[].

And if consseq_array is a local variable, and not a reference to a Tree element, then it should be declared as a ROW variable. but that only works in v6.
_________________
I am *not* the model of the modern major general.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Is there Array datatype in esql?

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