To speed it up, try resizing the file.
On 15 May 2013 21:44, Sathya 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 SOME.LIST' P
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
.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] De la part de Sathya
> Envoyé : mercredi 15 mai 2013 13:19
> À : u2-users@listserver.u2ug.org
> Objet : Re: [U2] select query..
>
> Manu Fernandes infodata.lu> writes:
>
>
> >
> > Hi
> &
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
e you can do a
straight read to check if it's 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 item
se if the list is large. This makes managing a
list directly in UD problematic. :-(
HTH,
Bill
- Original Message -
*From:* ggal...@wyanokegroup.com
*To:* U2 Users List
*Date:* 5/15/2013 6:43 AM
*Subject:* Re:
13 5:45 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] select query..
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 SOME.LIST&
BASIC READ
-Original Message-
From: Israel, John R.
To: U2 Users List
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
pass on the exact same results. The main purpose of a
AM
To: u2-users@listserver.u2ug.org
Subject: [U2] select query..
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 SOME.LIST
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 gmx.net> writes:
___
U2-Users mailing list
U2-Users listserver.u2ug.org
Actually
Mecki Foerthmann gmx.net> writes:
> >
>
> ___
> U2-Users mailing list
> U2-Users 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 I wil
What do you actually try to achieve?
On 15/05/2013 12:18, Sathya wrote:
Manu Fernandes 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 o
ME RTNLIST sellist CAPTURING junk
Tom Whitmore
RATEX Business 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]
Manu Fernandes 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 id
>
> Why do you want to use save-list/get-list ?
>
-Message d'origine-
> De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] De la part de Sathya
> Envoyé : mercredi 15 mai 2013 11:45
> À : u2-users@listserver.u2ug.org
> Objet : [U2] select query..
>
> Hi Experts..
>
> I have on
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 SOME.LIST' PASSLIST LIST1
LIST.NAME = "GET-LIST SOME.LIST"
sellist = ''
EXECUTE LIST.NAME RTNLIST selli
16 matches
Mail list logo