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
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