Re: dbaccess load & unload ?
Posted in 1997
"Billy Wheeler" — — source: Informix-list mailing list archive (1991-1998)
On 10 Mar 97 at 11:34, Matt Brickley wrote:
> If anyone can, please provide me the command line syntax for the
> LOAD, UNLOAD statements.
LOAD FROM "/usr/path/xxx.txt" INSERT INTO mytablename;
UNLOAD TO "/usr/path/yyy.txt" SELECT * FROM mytablename;
You can also look at the dbload command line utility which can be
used to load data more flexibly. If you want to recreate an entire
database, check out dbexport and dbimport.
The syntax for dbload is a little involved, but dbimport and dbexport
are simple:
dbexport databasename
dbimport databasename
There are more complex options available, check out:
dbimport -
dbexport -
HTH.
--
Ciao,
Billy
"...nod's as good as a wink to a blind bat..."