A quick question. Are you looking at UniVerse replication (the old style). Or
U2 replication in 11.1 on? They are quite different animals.
Regards
JayJay
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
On 17/10/12 16:40, George Gallen wrote:
How would I get the contents of the Index?
George
Don't have the UV BASIC manual in front of me, but it's something like
READINDEX variable FROM filedescriptor, indexname[, indexvalue]
If you only pass filedescriptor and indexname, it will return a
I think you mean
SELECTINDEX index.name[,key.val] FROM file.var [TO list.num]
Martin
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: 18 October 2012 08:55
To: u2-users@listserver.u2ug.org
Subject:
On 18/10/12 09:29, Martin Braid wrote:
I think you mean
SELECTINDEX index.name[,key.val] FROM file.var [TO list.num]
Martin
Followed by a READLIST ...
Quite possibly - I can't remember.
One *important* point to note - if you are planning to call this from an
i-descriptor, as I did, don't
Since the index files are actually type 25 files, you can always (though of
course I would NEVER recommend this ... ) create a file pointer direct to
the INDEX.nnn and read the entries as records ... saves grabbing a select
list ..
Brian
-Original Message-
From:
Sorry this is late to the conversation, but you may want to look at
http://www.pilotfishtechnology.com/
It's the swiss army knife of data integration. I'm using it in several
different ways. You could have it go consume a service and bring the response
back however you prefer.
-Original
Stupid question of the day on unidata 7.2.x
I build indexes all over to speed queries - I have plenty of disk to
burn. However does having an index help when sorting on a field that's
not part of the selection criteria? For example we often do this dance
between two files:
SELECT FILE
I'll have to play with this later - thanks for the info...
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Thursday, October 18, 2012 6:50 AM
To: 'U2 Users List'
Subject: Re: [U2] Selection
I can't say definitively, but I would expect the answer to be 'no'.
On Thu, Oct 18, 2012 at 6:39 AM, Jeffrey Butera jbut...@hampshire.eduwrote:
Stupid question of the day on unidata 7.2.x
I build indexes all over to speed queries - I have plenty of disk to burn.
However does having an index
No
-Original Message-
From: Jeffrey Butera jbut...@hampshire.edu
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Thu, Oct 18, 2012 5:39 am
Subject: [U2] Speeding sort
Stupid question of the day on unidata 7.2.x
I build indexes all over to speed queries - I have plenty of
George:
I wrote a TREE.CHECK program that does the following:
2 Dev (0)- TREE.CHECK MASTER -IINDEX_2
Index Check: MASTER, INDEX_1
?Key... Indexed Value.
?350 1432 1434 G ST CONDO ASSOC
?50 ABBOTT WOOD TOWNHOMES ASSOC
?70
There used to be a version of a SELECT verb on the Rocket website. I
think it was in the white papers or technical articles section. It
provided source code to a verb called SELECTK I think it was called.
If anyone can find it, let me know. I haven't been able to find it after
the first time
You can find it here:
https://u2devzone.rocketsoftware.com/accelerate/articles/u2-select/u2-select
Cheers,
Dan McGrath
Product Manager
Rocket Software
4600 S. Ulster Street **Suite 1100 **Denver, CO 80237 * USA
t: +1.720.475.8098 * m: +1.617.630.7392 * e:dmcgr...@rocketsoftware.com w:
What is the purpose of using a $ in one of your variable names?
-Original Message-
From: Bill Haskett wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Thu, Oct 18, 2012 9:24 am
Subject: Re: [U2] Selection Suggestions for using UV instead of SQL
I use it for EQUATE names to remind me that I can't change it when I'm
waist deep in a program.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, October 18, 2012 9:40 AM
To:
Sort of a carry-over from VB when a string was given a variable name
with a '$' in it, usually at the end, or the beginning. Habits die
hard. :-)
Bill
- Original Message -
*From:* wjhon...@aol.com
*To:*
In my first programming class in high school (on apple IIe's) we liked to
use G$ (with the $ pronounced as string)
Colin
-Original Message-
From: Bill Haskett
Sent: October 18, 2012 12:24 PM
To: U2 Users List
Subject: Re: [U2] Selection Suggestions for using UV instead of SQL
Sort
Speaking of the Apple II
AppleWorks was an excellent example of the days when changing the length of a
field required the entire database to be picked up and layed back down again.
And if you didn't have enough room to do that, you had to write it all to 35
floppy disks and then reload them.
And we wonder where GIRLS came from??!?
George Gallen
Senior Programmer/Analyst
Accounting/Data Division
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com
From: u2-users-boun...@listserver.u2ug.org
I will be out of the office starting 19/10/2012 and will not return until
22/10/2012.
I will respond to your message when I return. If urgent please phone the
helpdesk on 0038696 or from your handset and choose options 3 and1
First Capital Connect Limited. Registered in England Wales
however the absolute fastest would be to add an itype to FILE-1 that
accesses FILE-2 SORT_VALUE [you're already prepared to do multiple read on
2 files ]
OTH_FILE_SORT_KEY
001 I
002 TRANS('OTHER_FILE', SOME_KEY, '', 'X') where SOME_KEY is the
value you were saving from your example below
21 matches
Mail list logo