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 sellist
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 one issue here with fetching data from the file
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
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' PASSLIST LIST1
LIST.NAME = GET
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
@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' PASSLIST LIST1
LIST.NAME = GET-LIST SOME.LIST
sellist
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
16 matches
Mail list logo