1.首先登陆dbaccess
2.使用ftp命令,把数据上传到根目录
E:\>ftp xx.x.x.xx(host-IP)
Connected to xx.x.x.xx.
220 mc-nms-v4 FTP server (SunOS 5.8) ready.
User (xx.x.x.xx:(none)): informix
331 Password required for informix.
Password:
230 User informix logged in.
ftp> put ********.***(要上传的文件名)
200 PORT command successful.
150 Binary data connection for ************* (xx.xx.x.xxx,xxxx).
226 Transfer complete.
ftp: 发送 224396608 字节,用时 28.52Seconds 7869.15Kbytes/sec.
3.导入,导出
load from 文件名的绝对路径 insert into 表名;
unload to '输出文件绝对路径' select 表明;
4.导出以后再在ftp里中用get file_name就能得到该文件了
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11517198/viewspace-557375/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11517198/viewspace-557375/