dbexport - Informix

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

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" -- "I have enough problems remembering my opinions, let alone justifying them." "Sorry, I thought you tapped me."