Re: Transfering tables

Posted in 1997

Clem Akins — 19 Dec 1997 15:18:13 -0500 — source: Informix-list mailing list archive (1991-1998)

>We need to transfer some tables between 2 databases on a regular basis. Most >tables have referential constraints, there are hundred of tables we have to >look for. Is there an easy way to list the tables in order they should be >inserted first? The *easy* way would be to name the tables such that they occur in the desired order when you SELECT tabname FROM SYSTABLES... If the number of tables is stable then you could pipe that output through a head/tail filter to retrieve the desired subset of tables. ___________________________________________________________ Clem Akins (aka clem@informix.com) Informix Software, Inc (Standard disclaimers apply) International Technical Support Last seen: Learning more about 7.3 in Menlo Park, CA, USA