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 be multivalued? hth Colin Alfke Calgary Canada > From: wphaskett > > As a follow up, here's an index that was corrupted earlier: > > 2 Dev (0)-> LIST-INDEX ARTMASTER > Alternate Key Index Details for File ARTMASTER Page 1 > > File.................. ARTMASTER > Alternate key length.. 45 > Node/Block size....... 4K > OV blocks............. 1 (0 in use, 0 overflowed) > Indices............... 3 (0 D-type) > Index updates......... Enabled, No updates pending > > Index-Name...... F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr.... > INDEX_1 V Txt Yes Yes Yes Yes M > SUBR( '-CATS', SUBR( "T.LFM", NID, @FILE.NAME, @RECORD ), > REUSE(OCONV( *OCONV(@ID, 'G1*1' )*,'MR%7' ) ) ) > INDEX_2 V Txt Yes Yes Yes Yes M > SUBR( '-CATS', SUBR( "T.CLLFM",NID, @FILE.NAME,@RECORD, @ID ), > REUSE( OCONV( *OCONV( @ID, 'G1*1' )*, 'MR%7' ))) > INDEX_3 V Txt Yes Yes Yes Yes M > OCONV( *OCONV( @ID, 'G*1' )*, 'MR%4' ) : EXTRACT( PHADD, 1, 1, 0) > > > Thanks, > > Bill > > > >-----Original Message----- > > > >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 everything works fine, until > >the next time. > > > >Any thoughts would be appreciated. Thanks, > > > >Bill Haskett > >Advantos Systems, Inc. _________________________________________________________________ Find hidden words, unscramble celebrity names, or try the ultimate crossword puzzle with Live Search Games. Play now! http://g.msn.ca/ca55/212 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
