Re: dbexport

dbexport unloads the entire database. Use the SQL command "unload" exxample: UNLOAD TO "file" SELECT * FROM table_1 Don David Kulkarni wrote: > > On a system running Informix 5.10UC5 what syntax can I > use to export one particular table? Is it possible or > do I have to export the entire database. > > TIA > > __________________________________________________ > Do You Yahoo!? > Get Yahoo! Mail - Free email you can access from anywhere! > http://mail.yahoo.com/

FYI and FWIW UNLOAD is not an SQL command but a dbaccess built-in verb. You cannot, for example, execute UNLOAD from ESQL/C or CLI/ODBC (though 4GL also implements the unload verb as part of the language). Art S. Kagel Don Ignacio wrote: > > dbexport unloads the entire database. > > Use the SQL command "unload" > > exxample: > UNLOAD TO "file" > SELECT * FROM table_1> > Don > > David Kulkarni wrote: > > > > On a system running Informix 5.10UC5 what syntax can I > > use to export one particular table? Is it possible or > > do I have to export the entire database. > > > > TIA > > > > __________________________________________________ > > Do You Yahoo!? > > Get Yahoo! Mail - Free email you can access from anywhere! > > http://mail.yahoo.com/