You need to be more specific. When you say attribute 4 or attribute 5 equals the values, do you mean that every value in attribute 4 or attribute 5 should equal each element of the stored list (in order?), or that all values of attribute 4 or attribute 5 should be found anywhere in the stored list, or that any value of attribute 4 or attribute 5 is equal to any element of the stored list, or that any value of attribute 4 or attribute 5 correlates with a value at the same position in the stored list. Are attribute 4 and 5 even multivalued (though strictly speaking, they are multivalued even if they have no elements)?
Depending on what you mean (and with the CUBS software, it could be any of those ;-), you could generate a jQL statement: SELECT FILE WITH ATTR4 = "v1" "v2" "v3" ... OR WITH ATTR5 = "v1" "v2" "v3" .... Then use the resulting list to drive JCOPY. But the semantics of the select may not be what you are trying for. To be honest, it sounds like you are going about whatever it is you want to do, the wrong way. What you are trying to do will be very inefficient. Why don't you step back and say what you are trying to do, where this magic list is generated from and why it is generating a list. It would be very much more efficient to write a small program to do this and the program would take very little time to write. If this is going to be an application task that happens a lot, then you want a program that does the whole task and not have something else produce a list, then pick it up. Jim PS: Windows 2000? ;-) > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of Treg Taylor > Sent: Thursday, December 10, 2009 9:15 AM > To: [email protected] > Subject: JBASE: HowTo Select from a Select? > > All- > > TASK: Jcopy records from one file to another. > > ISSUE: I have a saved select list, I would like to select against a > file where attrib 4 or 5 equals the values from the saved select list. > Then copy the records to another file. > > If I were in sql, I would use an INNER JOIN or a WHERE - IN clause. > > Thanks in advance, > > Treg > ======== > System: Win2K CUBS 5.0 i386 > OS Release: Win 2000 Build 2195 Service Pack 4 > RELEASE Information: Major 3.4 , Minor 2 , Patch 05 > > > Notice: This electronic transmission and its attachments are > confidential and protected by applicable state and/or federal law. Any > use, reading, dissemination, distribution, copying or storage of this > information by anyone other than the intended recipient is strictly > prohibited. If you are not the intended recipient, please immediately > notify the sender by return email or telephone and delete this message > and its attachments from your system. > > -- > Please read the posting guidelines at: > http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > IMPORTANT: Type T24: at the start of the subject line for questions > specific to Globus/T24 > > To post, send email to [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
