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
