Hello,

Does anyone know the syntax of dbexport command if I need to unload only 1 table from Informix database? I could not find it anywhere.

Appreciate the help very much -- Anna

dbexport unloads data in the pipe delimited format.
you can do dbschema -d "dbname" -t "tabname" -ss > "tabname.sql"

and the run

dbaccess "dbname" <<!!
unload to "tabname.unl"
select * from "tabname"
!!


that way you will have the schema and the unload file.
if you need to do this for multipule tables you can script this.

Cheers