[U2] UD: Indexes

2008-06-12 Thread Bill Haskett
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

RE: [U2] UD: Indexes

2008-06-12 Thread Bill Haskett
] [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

RE: [U2] UD: Indexes

2008-06-12 Thread Colin Alfke
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

RE: [U2] UD: Indexes

2008-06-12 Thread Bill Haskett
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

RE: {Blocked Content} RE: [U2] UD indexes and UniQuery - redux

2007-08-31 Thread Bill Haskett
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

[U2] UD indexes and UniQuery - redux

2007-08-30 Thread Bill Haskett
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

{Blocked Content} RE: [U2] UD indexes and UniQuery - redux

2007-08-30 Thread colin.alfke
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

Re: [U2] UD Indexes

2006-04-12 Thread Simon Lewington
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

RE: [U2] UD Indexes

2006-04-12 Thread Bill Haskett
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

[U2] UD Indexes

2006-04-11 Thread 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 ...where the index looks like: :LIST ARTDESC INDEX_1 ARTDESC