MQSeries.net :: View topic - Using select statement to copy elements

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 » Using select statement to copy elements

Using select statement to copy elements

« View previous topic :: View next topic »

Author

Message

klabran

Posted: Wed Mar 03, 2004 10:00 am Post subject: Using select statement to copy elements

Master

Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ

I am trying to use the Select to copy a tree of elements but it only copies the the first element in each CHARGES_ROW. I want it to copy all of the elements in each CHARGES_ROW. What am I doing wrong? I am using MQSI 2.1.

SET OutputRoot.XML.Citation.CHARGES.CHARGE[]=(SELECT R.* FROM InputBody.Citations.Citation[I].CHARGES.CHARGES_ROW[] AS R);

Thanks,

Kevin

klabran

Posted: Wed Mar 03, 2004 10:47 am Post subject:

Master

Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ

I am not sure why this works but...

SET OutputRoot.XML.Citation.CHARGES.CHARGE[]=(SELECT R.TCMAINID,R.CHRG_SEQ,R.ARR_CHRG FROM InputBody.Citations.Citation[I].CHARGES.CHARGES_ROW[] AS R);

Explicity listing in the select clause works...

Why doesn't R.* work in the first post?

Anyone???

Kevin

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Using select statement to copy elements

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