Hi
Do you have wildcard characters like [] into KEYVALUE ?
If not, why do you SELECT ; it's the key of file.name ; you can read directly !
Elsewhere, For performance, set a index on the @id
Why do you want to use save-list/get-list ?
You can work on LIST1 directly !
manu
-Message
Manu Fernandes efv at infodata.lu writes:
Hi
Do you have wildcard characters like [] into KEYVALUE ?
If not, why do you SELECT ; it's the key of file.name ; you can read
directly !
Elsewhere, For performance, set a index on the at id
Why do you want to use save-list/get-list ?
Solutions
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya
Sent: Wednesday, May 15, 2013 7:19 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] select query..
Manu Fernandes efv at infodata.lu writes:
Hi
What do you actually try to achieve?
On 15/05/2013 12:18, Sathya wrote:
Manu Fernandes efv at infodata.lu writes:
Hi
Do you have wildcard characters like [] into KEYVALUE ?
If not, why do you SELECT ; it's the key of file.name ; you can read
directly !
Elsewhere, For performance, set a
Mecki Foerthmann meckif at gmx.net writes:
___
U2-Users mailing list
U2-Users at listserver.u2ug.org
Actually Im fetching the KEYVALUE data from a flat file and passing the
values one by one to the select command and creating the list.
Then
So you don't need to select at all.
Just use READ record FROM FILE.NAME,KEYVALUE ELSE record = '' in your loop.
On 15/05/2013 12:52, Sathya wrote:
Mecki Foerthmann meckif at gmx.net writes:
___
U2-Users mailing list
U2-Users at listserver.u2ug.org
You should not need to do the SAVE-LIST and GET-LIST unless you wish to do a
2nd pass on the exact same results. The main purpose of a SAVEDLIST is to
prevent you from having to do the same select multiple times (or to preserve
the list of keys for some other purpose). Note that a SAVEDLIST
BASIC READ
-Original Message-
From: Israel, John R. johnisr...@daytonsuperior.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, May 15, 2013 5:12 am
Subject: Re: [U2] select query..
You should not need to do the SAVE-LIST and GET-LIST unless you wish to do a
2nd
I'm confused..
If your doing a select with @ID = you will only get 1 response each time,
@ID is a primary key field. So as suggested just open the file, then do a read
from
That file with the given @ID.
An alternative to a SAVE.LIST and GET.LIST could be to open SAVEDLISTS as
file
Then
directly in UD problematic. :-(
HTH,
Bill
- Original Message -
*From:* ggal...@wyanokegroup.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 5/15/2013 6:43 AM
*Subject:* Re: [U2] select query..
I'm
there. However, the select shouldn't be
taking that long.
Hth
Colin
-Original Message-
From: Bill Haskett
Sent: Wednesday, May 15, 2013 9:41 AM
To: U2 Users List
Subject: Re: [U2] select query..
George:
In UniData, all SAVEDLISTS items have 000 (or 001, etc) appended to
the end of it. Although
On 15/05/13 18:43, Colin Alfke wrote:
That's what READLIST and WRITELIST are for. I've found writing the list as
MY.LIST000 to be relatively safe, when you read you would have to check
for MY.LIST000, then MY.LIST001, etc.
Sathya - as Mecki said, if you're using the @ID of the file you can
:19
À : u2-users@listserver.u2ug.org
Objet : Re: [U2] select query..
Manu Fernandes efv at infodata.lu writes:
Hi
Do you have wildcard characters like [] into KEYVALUE ?
If not, why do you SELECT ; it's the key of file.name ; you can read
directly !
Elsewhere, For performance
Erratum,
LOOP WHILE READNEXT KEYVALUE FROM LIST1 DO
-Message d'origine-
De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] De la part de Manu Fernandes
Envoyé : mercredi 15 mai 2013 21:10
À : U2 Users List
Objet : Re: [U2] select query..
Hi
To speed it up, try resizing the file.
On 15 May 2013 21:44, Sathya sathya8...@gmail.com wrote:
Hi Experts..
I have one issue here with fetching data from the file.
EXECLINE = SELECT FILE.NAME WITH @ID = \:KEYVALUE:\
DISPLAY EXECLINE
EXECUTE EXECLINE RTNLIST LIST1
EXECUTE 'SAVE-LIST
15 matches
Mail list logo