Re: Reducing Table Sizes

In article <6m3tkn$qlg$1@news.xmission.com>, Herb Blacker <herbb@jcdcrs4.jobcorps.org> writes > >Here's a thought...I wish to copy a database to a *test* instance, but I >don't need the tables to be as large as those in the production DB. >What I was thinking...and I could be way off base here...is that if I >did a DBEXPORT, then edited the <dbname>.sql file to reduce the number >of rows where the table is being created, and *also* edited the >corresponding <tabname>.unl file to remove all but the # of rows I want >to import - will the DBIMPORT work or not? > Should do... >----------------------------------------------- >Herb Blacker >Cimarron, Inc. >Sr. Database Administrator >Dept. of Labor Job Corps, San Marcos, Texas >----------------------------------------------- > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care