No, and Yes.
Just doing a SELECT in SQL style on UV gives you a crt display of the
result set. But if you use the SLIST extension, you can then access the
select list (see System Description manual) as "normal" for the UV
environment.
--
Regards,
Clif
~~~
I will be the first to admit that I know next to nothing about SQL in the
UV/UD world.
Can you use the output of the SQL SELECT in UV/UD?
Thanks.
Steve
At 05:14 PM 5/1/04 +1000, you wrote:
Gordon J. Glorfield wrote:
> In that case, I'm sorry to say, there is no way to logically
> do what yo
le of Micro$oft SQL servers along with the
UniVerse machines.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Ken Wallis
Sent: Saturday, May 01, 2004 3:15 AM
To: 'U2 Users Discussion List'
Subject: RE: [UD] Union Query
Gordon J. Glorfield wrote:
Gordon J. Glorfield wrote:
> In that case, I'm sorry to say, there is no way to logically
> do what you're asking with UD.
Gordon, you should now better! ;^)
sql> SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE UNION SELECT NAME
ADDRESS CITY STATE ZIP FROM ORDER_FILE_OTHER;
All you need here
In a message dated 4/30/2004 10:11:05 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
> > > 001: I
> > > 002:
> TRANS("ORDER.FILE",@ID,3,""):TRANS("ORDER.FILE.CAN",@ID,3,"")
> > > 003:
> > > 004: NAME
> > > 005: 25L
> > > 006: S
But could'nt you do something like
IF TRANS("ORDER.FILE",@ID,3
ed to know as well.
Thanks.
- Original Message -
From: "Bruce Lunt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 30, 2004 10:11 PM
Subject: Re: Memo: RE: [UD] Union Query
> Open mouth, ... insert foot. Or whatever :)
>
> I'm sorry, I
MAIL PROTECTED]>
Subject: Re: Memo: RE: [UD] Union Query
Date: Fri, 30 Apr 2004 14:41:17 -0400
From: "Burwell, Edward" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Friday, April 30, 2004 2:00 PM
Subject: RE: Me
)
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: Bruce Lunt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 3:59 PM
To: [EMAIL PROTECTED]
Subject: RE: Memo: RE: [UD] Union Query
In the dict of FILE.A create a dict called: NAME.LO that has:
TRANS("LOC
cell
From: "Burwell, Edward" <[EMAIL PROTECTED]>
Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]>
To: 'U2 Users Discussion List' <[EMAIL PROTECTED]>
Subject: RE: Memo: RE: [UD] Union Query
Date: Fri, 30 Apr 2004 13:41:26 -0400
R. Bruce,
Could you give
From: "Burwell, Edward" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Friday, April 30, 2004 2:00 PM
Subject: RE: Memo: RE: [UD] Union Query
> Does that work for you? It doesn't work for me.
>
> ORDER.FI
What is a Distributed File?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 2:35 PM
To: [EMAIL PROTECTED]
Subject: Re: [UD] Union Query
In a message dated 4/30/2004 10:12:57 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> I hav
In a message dated 4/30/2004 10:12:57 AM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
> I have 2 files in separate accounts that are structured the same. I want to
> do something like:
>
> SORT ORDER.FILE AND ORDER.FILE.OTHER WITH DATE >
> "01/01/2004" NAME ADDRESS
> CITY STATE ZIP
Is the
ORDER.FILE",@ID,3,""):TRANS("ORDER.FILE.CAN",@ID,3,"")
003:
004: NAME
005: 25L
006: S
-Original Message-
From: Allen Egerton [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 1:47 PM
To: U2 Users Discussion List
Subject: Re: Memo: RE: [UD] Union Query
From: "Burwell, Edward" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Friday, April 30, 2004 1:41 PM
Subject: RE: Memo: RE: [UD] Union Query
> R. Bruce,
>
> Could you give an example? I'm having trouble e
d the NAME dictionary look like?
Thanks.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: Bruce Lunt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 12:26 PM
To: [EMAIL PROTECTED]
Subject: RE: Memo: RE: [UD] Union Query
What I have done in the past is concate
lt;[EMAIL PROTECTED]>
Subject: Memo: RE: [UD] Union Query
Date: Fri, 30 Apr 2004 16:49:46 +0100
Hi Ed,
You could test for the record existing in one file and if it does use the
dict for that file otherwise use the dict for the other file:
TRANS("FILE.A",ID,1,"X"); IF @1 <&
o:'U2 Users Discussion List' <[EMAIL PROTECTED]>
cc:
bcc:
Subject:RE: [UD] Union Query
@ID in this case points to the filename mentioned in my statement:
LIST ORDER.FILE
the @ID's from ORDER.FILE.OTHER are showing up as non-existent:
(My merged list contains 1
I don't have two files of that type to test with here, but would a SQL query work for
this?
Don Kibbey
Financial Systems Manager
Finnegan, Henderson, Farabow, Garrett & Dunner LLP
>>> [EMAIL PROTECTED] 04/30/04 10:12AM >>>
Hello,
Does anyone know of a way to do the equivalent of a UNION "quer
ubject: RE: [UD] Union Query
No, a record ID in one file will not exist in the other file.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
oper
MAMSI (A UnitedHealth Company)
301-360-8839
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward
> Sent: Friday, April 30, 2004 11:24 AM
> To: 'U2 Users Discussion List'
> Subject: RE: [UD] Union Que
ECTED]
Sent: Friday, April 30, 2004 11:18 AM
To: [EMAIL PROTECTED]
Subject: RE: [UD] Union Query
My suggestion is to create a "V" type dictionary item(s) that with point to
your other file.
For example, if you want to look at the city name in your file,
ORDER.FILE.OTHER, create the followi
No, a record ID in one file will not exist in the other file.
-Original Message-
From: Jeff Schasny [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 11:14 AM
To: U2 Users Discussion List
Subject: RE: [UD] Union Query
TCL (or whatever your flavor calls the queery language) is a
Phone: (703) 334-0156
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Web:www.bench.com <http://www.bench.com>
-Original Message-
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 11:05 AM
To: 'U2 Users Discussion List
elate?
-Original Message-
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 8:05 AM
To: 'U2 Users Discussion List'
Subject: RE: [UD] Union Query
I understand how Unibasic could handle a list that has been merged, but how
would you do a Uniquery statemen
Thanks.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 10:27 AM
To: 'U2 Users Discussion List'
Subject: RE: [UD] Union Query
You could use MERGER.LIST to get one list which is a U
You could use MERGER.LIST to get one list which is a UNION of two separate
selects of each file. But you would not know which file the key was from
when you were done. But Unibasic or Virtual dictionary items could take the
merged list and produce what you are looking for.
-Original Message--
26 matches
Mail list logo