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
