Greg, No.
CMD serves to EXECUTE all three statements with one EXECUTE statement and therefore in one workspace. With separate EXECUTE statements, the results of each statement resides in its own workspace and, on some platforms (including Universe), are not available to a statement EXECUTEd in another work space. In this event, the last statement in the first example would have no LIST 1 to merge and no LIST 2 to merge into. I've never seen the stacking of statements into a single variable (eg. CMD) and then executed - that's a neat idea, because the sequence in which the statements will be executed is obvious. The alternative approach is to use DATA statements before the last and only EXECUTE statement, in which the sequence of execution is from the EXECUTE statement up. I don't know if there are any functional differences, but if not, I like this approach much better. Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com ----- Original Message ----- From: "Coelho, Gregory" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, January 23, 2006 8:38 AM Subject: RE: [U2] RE:MERGE SAVE.LISTS > George, > > Thanks! This may be what all the additional coding was trying to > address - Isn't CMD<-1> directing the inclusion of all keys to one > record instead of 2? I'll look into this. Again, Thanks! > > Greg > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen > Sent: Monday, January 23, 2006 9:41 AM > To: [email protected] > Subject: RE: [U2] RE:MERGE SAVE.LISTS > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of > > Coelho, Gregory > > Sent: Monday, January 23, 2006 8:43 AM > > To: [email protected] > > Subject: RE: [U2] RE:MERGE SAVE.LISTS > > > > > > Colin, > > > > Thanks for the steer. For some reason the code that I inherited had > > some 30 lines dedicated to merging 2 saved lists. The focus > > seems to be > > restructuring the keys. It doesn't work. The traditional approach > > works like a champ and is delivering the expected data. I'll explore > > the List commands... Thanks again for the help. > > > > Greg > > > > EXECUTE "GET.LIST SL.LIST1 TO 1" > > EXECUTE "GET.LIST SL.LIST2 TO 2" > > EXECUTE "MERGE.LIST 1 UNION 2" > > Etc. > > I've had issues sometimes setting up the merge like above, and had to > use > > CMD="" > CMD<-1>="GET.LIST SL.LIST1 TO 1" > CMD<-1>="GET.LIST SL.LIST2 TO 2" > CMD<-1>="MERGE.LIST 1 UNION 2" > EXECUTE CMD > > George > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
