I think that what Treg is asking is how to do something like the following:
SELECT FILE1 SAVE-LIST MYLIST SELECT FILE2 WITH ATTR4 EQ MYLIST So, the question is how to use a selection to select records in other file not by id, but by another attribute. I'd like to know if it's possible to, it would make my life easier. Regards Jose 2009/12/11 Daniel Klein <[email protected]> > SELECT file1 *A4 *A5 > SAVE-LIST mylist > GET-LIST mylist > SELECT file2 > > If the data is multi-valued or sub-valued then construct a dictionary > items like this: > > ID: A4 > 001 I > 002 @RECORD<4,1,1> > 003 > 004 > 005 10L > > ID: A5 > 001 I > 002 @RECORD<5,1,1> > 003 > 004 > 005 10L > > then change the first statement to: > > SELECT file1 A4 A5 > > Dan > > On Thu, Dec 10, 2009 at 4:03 PM, Treg Taylor > <[email protected]> wrote: > > Jim: > > > > I know, I know, Win2K.... arrggghhhh; thems the breaks. > > > > Well this is a mute point now, as the data extract requirements have > changed. > > > > FYI: I was looking at identifying rows in one file where attrib 4.1.1 or > attrib 5.1.1 was listed in a file of 61K rows. > > > > Thanks for your help > > > > Treg > > > > > > > > -----Original Message----- > > From: [email protected] [mailto:[email protected]] On Behalf > Of Jim Idle > > Sent: Thursday, December 10, 2009 2:22 PM > > To: [email protected] > > Subject: RE: JBASE: HowTo Select from a Select? > > > > 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 > > > > 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 > -- 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
