- 论坛徽章:
- 0
|
在im.sql文件里写如下文件:
CONNECT TO AIXDB
echo Import CENTERINFO
IMPORT FROM /home/db2inst1/sqllib/import/centerinfo.txt OF DEL MODIFIED BY chardel"" coldel, decpt. MESSAGES /home/db2inst1/sqllib/import/1a.txt INSERT INTO DB2ADMIN.CENTERINFO
--echo Import ADVERINFO
--IMPORT FROM /home/db2inst1/sqllib/import/adverinfo.txt OF DEL MODIFIED BY chardel"" coldel, decpt. MESSAGES /home/db2inst1/sqllib/import/2a.txt INSERT INTO DB2ADMIN.ADVERINFO
--echo Import FTPINFO
--IMPORT FROM /home/db2inst1/sqllib/import/ftpinfo.txt OF DEL MODIFIED BY chardel"" coldel, decpt. MESSAGES /home/db2inst1/sqllib/import/3a.txt INSERT INTO DB2ADMIN.FTPINFO
出现SQL3015N错误,在MESSAGES 1a.txt文件了出现SQL0007N错误
求教能db2 -f im.sql文件执行多个IMPORT命令吗?
各位大虾指点一下 |
|