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 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: [email protected] > >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 > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > -- -Kevin http://www.PrecisOnline.com ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
