Re: How to onunload for list of tables

musman@my-deja.com wrote: > > Hi > > We are using Informix 7.3 IDS on Sun Solaris 2.6 operating system. I > have more than 5000 tables in my database. I tried to write a script to > export required tables. The script performs only the first line and it > comes back to unix prompt. I am failed to understand, can anyone help > me on this? Wow, you only have 2 companies? > Script > ------ > onunload -t ttccom010777 baan:ttccom010777 << @ 2>&1 > onunload -t ttiitm001777 baan:ttiitm001777 << @ 2>&1> > shall be grateful on any help Well first off, the shell syntax is waiting for input up to the first "@" in column 1. That is what "<<@" means. Also I think the -t option requires the -s and -b options. But lastly, what do you intend to do with the tables once unloaded? Are they being transferred from company 777 to another company? If so then they will need renaming. It is usually more practical (not easier) to use the Baan dump and reload utilities to move Baan tables. You have all sorts of problems with the Baan referential data that Baan maintains. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+