Has anyone had trouble with UniData indexes? We moved an application from D3
to UD
and it's been reported that indexes are needing to be rebuilt on a recurring
basis.
We created a program that will delete the index then rebuild it for needed
dictionary
items. After this program is run
] [mailto:owner-u2-
[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Thursday, June 12, 2008 5:38 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UD: Indexes
Has anyone had trouble with UniData indexes? We moved an application from
D3 to UD and it's been reported that indexes are needing
Bill;
We haven't had trouble since an early version of version 6 had an overly
optimized version of udtsort.
Are any of those subroutines returning data from a remote file? UniData
doesn't have a link to the remote file to know when it's updated so the index
won't be updated.
Are they supposed
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UD: Indexes
What exactly are these subroutines doing?
On Thu, Jun 12, 2008 at 6:51 PM, Bill Haskett [EMAIL PROTECTED]
wrote:
As a follow up, here's an index that was corrupted earlier:
2 Dev (0)- LIST-INDEX ARTMASTER
Alternate Key Index
figure out some kind of resolution.
Thanks,
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, August 30, 2007 8:51 PM
To: u2-users@listserver.u2ug.org
Subject: {Blocked Content} RE: [U2] UD indexes and UniQuery - redux
I've been having problems getting UniQuery to use defined (and built) indexes in
UniData. IBM has informed me that UniQuery does not use indexes unless the
exact
alternate key is used. e.g.
:SELECT NAMES WITH INDEX_1 = JOHNS]
or
:select NAMES WITH INDEX_1 LIKE
Warning: This message has had one or more attachments removed
Warning: (not named).
Warning: Please read the AngelicHost-Attachment-Warning.txt attachment(s)
for more information.
Bill;
We use them all the time. They make a huge difference (especially on the
older, slower systems).
I don't know
Bill Haskett ...
I'm running UD v7.1 and got an error message from within a BASIC program
like:
In E:\DataTrust\DTA\BP\BP\_TRREC at line 1161 - is not an indexed/legal
field.
..caused by the BASIC statement:
SETINDEX NAME.KEY, A.CODE ON ARTDESC
...
Am I correct in assuming that UniData
Simon:
Thanks very much. I'll pursue this immediately. :-)
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Simon Lewington
Sent: Wednesday, April 12, 2006 1:35 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UD Indexes
Bill
I'm running UD v7.1 and got an error message from within a BASIC program
like:
In E:\DataTrust\DTA\BP\BP\_TRREC at line 1161 - is not an indexed/legal
field.
...caused by the BASIC statement:
SETINDEX NAME.KEY, A.CODE ON ARTDESC
...where the index looks like:
:LIST ARTDESC INDEX_1
ARTDESC
10 matches
Mail list logo