...@listserver.u2ug.org] On Behalf Of Hilk, Brandon
Sent: Wednesday, 28 August 2013 6:24 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Select from one file with save-list from another file
Hello!
UniVerse 10.1, HP/UX, Pick.
Is there a way I can build a save-list from a selection from on
hi,
like the same post from a few month, use direct access to btree indexfile (type
25) you can do it like this :
1) add a index on Y.INFO:PACKET.ID (create.index + build.index)
2) set a VOC entry to the btree file I_Y.INFO/INDEX.000 (000 can be different)
ED VOC YINFO.PACKETID
001 F
002 I_Y.I
What message do you get, when you try to create new Dict entries?
-Original Message-
From: Hilk, Brandon
To: U2 Users List
Sent: Wed, Aug 28, 2013 9:06 am
Subject: Re: [U2] Select from one file with save-list from another file
Not myself, no. I could get with the programming
AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Select from one file with save-list from another file
Do you have the ability to create new DICT entries in both X.INFO and
Y.INFO ?
-Original Message-
From: Hilk, Brandon
To: U2 Users List
Sent: Wed, Aug 28, 2013 8:09 am
Su
t;ccc" BILL.DAY BILL.AMT X.DOB
Etc.?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hilk, Brandon
Sent: Wednesday, August 28, 2013 8:07 AM
To: U2 Users List
Subject: Re: [U2] Select from one file with save-list from anot
Do you have the ability to create new DICT entries in both X.INFO and Y.INFO ?
-Original Message-
From: Hilk, Brandon
To: U2 Users List
Sent: Wed, Aug 28, 2013 8:09 am
Subject: Re: [U2] Select from one file with save-list from another file
Thanks everyone, I've got
Thanks everyone, I've got some usable info to work with. Sorry if my
original post was a bit vague, let me illustrate to clarify:
X.INFO
@PACKET.ID.NAME..DOB...STATUS
52781456.52781456..DOE, JOHN.06-17-1985CCC
Y.INFO
@
2013 15:04
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Select from one file with save-list from another file
This line caught my eye:
> readlist var from 10 else then result = lower(var)
"else then" ?
I get it, but ... yuck. :)
T
> From: Martin Phillips
> Spotted
This line caught my eye:
> readlist var from 10 else then result = lower(var)
"else then" ?
I get it, but ... yuck. :)
T
> From: Martin Phillips
> Spotted a bug - I knew this would turn out to be the wrong source
> code!!...
___
U2-Users mailing li
-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips
Sent: 28 August 2013 13:55
To: 'U2 Users List'
Subject: Re: [U2] Select from one file with save-list from another file
Hi,
Long ago, I wrote an OUTERJOIN() fun
0
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: 28 August 2013 13:18
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Select from one file with save-list from another file
Not sure where to
Not sure where to toss this into this thread so I'll start at the
beginning. I wanted to see the solutions that would be offered. I
blogged on exactly this topic back in 2008. The solution I published
for D3 uses @environment variables to allow us to do inner queries
with a tiny bit of simple and r
n be a quick way to export some data...
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hilk, Brandon
Sent: Tuesday, August 27, 2013 1:24 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Select from one file with save-lis
be a quick way to export some data...
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hilk, Brandon
Sent: Tuesday, August 27, 2013 1:24 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Select from one file with save
?
-Original Message-
From: Wols Lists
To: u2-users
Sent: Tue, Aug 27, 2013 5:30 pm
Subject: Re: [U2] Select from one file with save-list from another file
On 28/08/13 01:20, Wjhonson wrote:
Yes I think you could use an On The Fly statement like the EVAL to do the
trans if you can
Yes, because (at least on UV) it actually writes a temporary record to the
dictionary to perform the EVAL expression.
On Tue, Aug 27, 2013 at 6:37 PM, Wjhonson wrote:
> Are you implying that it somehow reads the permissions of the dictionary
> before allowing the use of EVAL?
>
>
__
Are you implying that it somehow reads the permissions of the dictionary before
allowing the use of EVAL?
-Original Message-
From: Wols Lists
To: u2-users
Sent: Tue, Aug 27, 2013 5:30 pm
Subject: Re: [U2] Select from one file with save-list from another file
On 28/08/13 01
Message-
> From: Allen Elwood (TW)
> To: U2 Users List
> Sent: Tue, Aug 27, 2013 5:13 pm
> Subject: Re: [U2] Select from one file with save-list from another file
>
>
>
> forgot to mention, david green knows a way of doing this with some fancy
> statements, i
tserver.u2ug.org
Subject: Re: [U2] Select from one file with save-list from another file
SELECT CUSTOMERS WITH STATE = 'AZ' SAVING ORDER.ID
LIST ORDERS
From: r...@lynden.com
To: u2-users@listserver.u2ug.org
Date: Tue, 27 Aug 2013 14:42:34 -0700
Subject: Re: [U2] Select from one fil
>>
>>
>> -Original Message-
>> From: Rick Nuckolls
>> To: 'U2 Users List'
>> Sent: Tue, Aug 27, 2013 4:01 pm
>> Subject: Re: [U2] Select from one file with save-list from another file
>>
>>
>> Your response supposes t
'U2 Users List'
Sent: Tue, Aug 27, 2013 4:01 pm
Subject: Re: [U2] Select from one file with save-list from another file
Your response supposes that the ORDER.ID IS is in the CUSTOMERS file/table,
which is not the criteria of the original problem.
The problem presented is a bit di
--Original Message-
From: Rick Nuckolls
To: 'U2 Users List'
Sent: Tue, Aug 27, 2013 4:01 pm
Subject: Re: [U2] Select from one file with save-list from another file
Your response supposes that the ORDER.ID IS is in the CUSTOMERS file/table,
which is not the criteria of the original p
IC "SELECTINDEX" function.
-Rick
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jo Lester
Sent: Tuesday, August 27, 2013 2:54 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Select from one file with
which can be a quick way to export some data...
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hilk, Brandon
Sent: Tuesday, August 27, 2013 1:24 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Select from one file
SELECT CUSTOMERS WITH STATE = 'AZ' SAVING ORDER.ID
LIST ORDERS
> From: r...@lynden.com
> To: u2-users@listserver.u2ug.org
> Date: Tue, 27 Aug 2013 14:42:34 -0700
> Subject: Re: [U2] Select from one file with save-list from another file
>
> I found an old exampl
24 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Select from one file with save-list from another file
Hello!
UniVerse 10.1, HP/UX, Pick.
Is there a way I can build a save-list from a selection from one file
X.INFO (where the record ID is an 8 digit number) and use that list to
selec
users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Elwood
(TW)
Sent: Tuesday, August 27, 2013 3:51 PM
To: U2 Users List
Subject: Re: [U2] Select from one file with save-list from another file
i made a relational selection program many many moons
i made a relational selection program many many moons ago - i'm retired
now - thanks to a crushed right hand i can only type with the left hand
which goes numb quickly thanks to an elbow injury
but i keep the code around and lurk on the list just in case :-)
* RSELECT - Relational File Selec
Hello!
UniVerse 10.1, HP/UX, Pick.
Is there a way I can build a save-list from a selection from one file
X.INFO (where the record ID is an 8 digit number) and use that list to
select from file Y.INFO (where that 8 digit number is not the record ID
but does exist as a "foreign key" elsewher
29 matches
Mail list logo