Monday 23 July 2012

DB import, export and DB load commands in Informix

DB Export:
dbexport database name [-o dir]
example:
dbexport sysdbs -o tmp
DB Import:
dbimport [-d dataspace] [-dir] database
example:
dbimport -d workdbs - tmp sysdbs

dbload  command:

dbload [-d database] [-c commandnfile] [-l error log] [-n number of rows after commit] [-e number of rows discarded]

command file:
unlfile *,unl delimiter number of fields;
insert statement;
example:
unlfile a.unl delimiter "|" 10;
insert into employee;

dbload -d sysdb -c a.unl -l error.log -n 100 -e 100

No comments:

Post a Comment