UniData has memresize which allows you to specify memory and tmp path settings which can make the resize go much faster. There is also a fileinfo function that can quickly provide the file "header" information. Not sure if UniVerse has something equivalent.
hth -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles >-----Original Message----- >From: "Dmitry Zhirov" [mailto:[EMAIL PROTECTED] >Sent: Thursday, April 15, 2004 5:08 AM >To: [EMAIL PROTECTED] >Subject: Modulo & Separation > > >Hi all! > [SNIP] > >If records are less than 4000 it's no problem to use RESIZE operator >but in the case they are greater than 4000 RESIZE takes more >than 3 hours. >How to make RESIZE work faster? > >----- >Which is the best way to count modulo & separation? > > >Thanks in advance. >Dmitry Zhirov >INTERPROMBANK >Moscow > >РБД -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users