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', S UBR( "T.LFM", NI D, @FILE.NAME, @ RECORD ), REUSE( OCONV( *OCONV( @ID, 'G1*1' )*, 'MR%7' ) ) ) INDEX_2 V Txt Yes Yes Yes Yes M SUBR( '-CATS', S UBR( "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' )*, 'M R%4' ) : EXTRACT ( PHADD, 1, 1, 0 ) Thanks, Bill >-----Original Message----- >From: [EMAIL PROTECTED] [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 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. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/