Re: dbexport - Informix

TBP wrote: > annabz wrote: > >> Hello, I am trying to run dbexport in Informix database on NT to export >> just one table, not the whole database. Does anyone know the syntax of >> the >> dbexport command to export only 1 table? >> >> Many thanks -- Anna >> > > Interesting :D > > Well, you would have to use a combination of > > dbschema -d databasename -t tablename (-ss)> unload to "table.unl" select * from tablename;> > Then use the dbschema produced to create the table > then > load from "table.unl" insert into tablename> > Or you could use onunload to go from / to the same version > > Or you could use dbschema and then remote selects > > But, yes, this sounds like a nice feature reqeust : > > "Add table selectivity to the dbexport command" > Instead of Unload/Load you could use INSERT INTO tablenamebk SELECT * FROM tablename