hmmm. that would work. I was hoping to not use a dict item, as it could be 1 of many source files.
Thanks George > -----Original Message----- > From: [email protected] [mailto:owner-u2- > [email protected]] On Behalf Of Jeff Fitzgerald > Sent: Friday, April 24, 2009 2:58 PM > To: [email protected] > Subject: RE: [U2] How do you do a NOPAGE on a SELECT? > > George, > > If I understand correctly you are trying to end up with a list > of the VARB1's from FILE1 that are valid record keys in FILE2, correct? > > If I'm right so far, what I'd do is create an I-descriptor in > FILE1 that does a TRANS to FILE2, like this: > > CHECK.FILE2 > 0001: I > 0002: TRANS("FILE2", VARB1, 0, "X") > ... > > TRANS works for multivalued fields, by the way. So then your > SELECT could be: > > SELECT FILE1 WITH CHECK.FILE2 # "" SAVING VARB1 > > SAVE-LIST XX > > > HTH, > > Jeff Fitzgerald > Fitzgerald & Long, Inc. > www.fitzlong.com > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of George Gallen > Sent: Friday, April 24, 2009 12:22 PM > To: [email protected] > Subject: [U2] How do you do a NOPAGE on a SELECT? > > ok...(UV 10 ) > > I'm doing the following: > > SELECT FILE1 SAVING VARB1 (PICK format SELECT - to allow multivalued > SAVING) SELECT FILE2 SAVE-LIST XX > > Problem is when there are VARB1 items in FILE1 that are not valid ID's > in > FILE2 > the SELECT FILE2 displays all the ID's that are not valid ID's. > > If I'm typing the commands, no problem...just hit 'n', however, if I > put > them in a VOC, and execute the VOC from a program, the operator has to > hit 'n'. > > What would be nice would be if there was a NOPAGE, or a HUSH option to > SELECT. > > My workaround is: > > SELECT FILE1 SAVING VARIB1 TO 1 > SELECT FILE2 TO 2 > MERGE.LIST 1 INTERSECT 2 > SAVE-LIST XX > > 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/
