I am querying a file with multivalued fields but I am not getting a
precise enough selection. I want to find only those records where the
multivalues for two separate fields meet the criteria within the same
index.
The file is the order-log file. There is only one record for each order
number but
This is a classic MV situation that is over 25 years old.
I don't know the platform and if it supports associated fields. But,
traditionally, selects against 2 fields are often taken as 2 separate
selects.
The classic repair is to concatenate the requested pair into one dict item
and select it
This is only a stab...
if you make field 7 the name of a phrase, say ACT.ACT, for the dict
item, with the phrase being in the same dict as
PH
ACTION ACT.DTE
then do the same query?
On 10/11/05, Jeff Powell [EMAIL PROTECTED] wrote:
I am querying a file with multivalued fields but I am not getting
U2 is not a database. UniData or UniVerse ?
On UniData try HELP WHEN and look at the explanation of the ASSOCIATED
keyword
I think you're looking for
WHEN ASSOCIATED action = PCK AND act.date = (today)
but you need to make sure the file dictionary is correctly set up
also only works in ECLTYPE
Original Message
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
Sent: Monday, October 10, 2005 5:15 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Basic vs Execute Select
A recent thread debated the speed of these 2 SELECT methods.
My question is what
Jeff Powell wrote:
I am querying a file with multivalued fields but I am not getting a
precise enough selection. I want to find only those records where the
multivalues for two separate fields meet the criteria within the same
index.
The file is the order-log file. There is only one record for
Jeff:
If you don't have the usual U2 dictionary types (you have Pick S/A types)
try:
LIST ORDER-LOG BY-EXP ACTION = pck BY-EXP ACT.DATE = 10/11/05 .
That should do the trick. Hope this helps.
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
They began developing a client-server product about 1990, using OS/2 and
Modula-2 and Sybase. Over the years they moved to Windows, went through C,
C++, and are now using Java, and the database preferences are Oracle, MS SQL,
and DB2 (I believe).
The private investors who bought the company
EXECUTE COUNT FILENAME
Mark Johnson [EMAIL PROTECTED] wrote:
A recent thread debated the speed of these 2 SELECT methods.
My question is what would be the preferred way to insure that all records may
be counted for on an active system instead of a dormant system.
Thanks in advance.
Mark
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Timothy Snyder
Sent: Friday, October 07, 2005 5:21 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] OPEN vs TRANS
Now, as to people who want to code one line instead of two (e.g.: the
topic
Ralph Burton [EMAIL PROTECTED] wrote on 10/11/2005 01:30:19 PM:
Any suggestions on Redback training/education?
Here's a good place to start. ;-)
http://www-304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=pagecontentID=a523
Tim Snyder
Consulting I/T Specialist , U2
Hi,
Does anyone have an up2date /etc/magic file component for UV files (up
to an including UV 10 and 64-bit files) on HP Alpha platform? If so, are
they able to make it available?
Cheers,
Phil
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
WITH selects records. WHEN only suppresses display of multivalued fields that
do not meet your selection criteria.
UniVerse/SQL makes this clearer, since you must specify both the selection
clause and the suppression clause. You can do this with LIST as well.
LIST filename field_list WITH
We do and have done RedBack training for over 4 years now. Call us for
rates and availability 303-768-9601.
Doug Averch
www.u2logic.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ralph Burton
Sent: Tuesday, October 11, 2005 11:30 AM
To:
Has anyone had any luck in getting the U2 Client tool XMLDBTool to work
(Connect) ?
I'm trying to connect to a UV server on a W2K platform. I'm using the
default settings for transport type and rpc port #. It seems to hang so
I haven't been able to connect to my server.
Anything I'm
What are you using?
Does it work well?
Would you use it today if you doing development or consider something else?
Thanks,
Ralph
P.S. Thanks for the Training responses too.
-
Yahoo! Music Unlimited - Access over 1
Comments interspersed...
Doug Averch
www.u2logic.com
Software Solutions and Tools for U2.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ralph Burton
Sent: Tuesday, October 11, 2005 5:39 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Redback - What
Folks,
We are considering a server consolidation exercise, particularly for our
Development and Test environments, using VMWare to provide several
'virtual server' environments on a single physical box. One part of
this proposal is that my UniVerse Development server will become a
virtual server
George Gallen [EMAIL PROTECTED] wrote on 10/11/2005 02:01:52 PM:
Also, I don't use the OCONV() method with corelatives, I use the
VAR=RAISE(TRANS(filename,itemname,-1,'x')), which is pretty self
commenting, of course, that requires you to know what the TRANS()
keyword does.
I'm still trying
Michael ,
Yes is the answer, we've be trialling UV (10.1.12)/VMware and also
with SUSE/Xen. Both of which work/play with UV just fine (so far).
We are setting up 'single' user development environments for each
developer and a floating number of test environments. We
Just because you can doesn't mean you should.
UniVerse has many ways of doing things, some well and others not so
well. I like you cannot se any benefit in using a TRANS...
My 2 cents
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder
21 matches
Mail list logo