标题: 用rsh执行远程DB2命令的例子,在AIX上
燕狂徒
版主
Rank: 15Rank: 15Rank: 15Rank: 15Rank: 15


LU爱心使者  
UID 59
精华 14
积分 1707
帖子 3208
活跃指数 155
LU金币 4924 个
LU金条 616 个
阅读权限 210
注册 2003-9-19
 
发表于 2003-11-16 23:09  资料  个人空间  主页 短消息  加为好友 
下面是一个用rsh执行远程DB2命令的例子,在AIX上,会得到下面的输出:
rsh hostname ". /home/db2inst1/sqllib/db2profile;db2 connect to sample; db2 \"select * from db2inst1.employee fetch first 3 rows only\";db2 connect reset"

Database Connection Information

Database server = DB2/6000 7.2.0
SQL authorization ID = DB2INST1
Local database alias = SAMPLE

EMPNO FIRSTNME MIDINIT LASTNAME WORKDEPT PHONENO HIREDATE JOB EDLEVEL SEX BIRTHDATE SALARY BONUS COMM
------ ------------ ------- --------------- -------- ------- ---------- -------- ------- --- ---------- ----------- ----------- -----------
000010 CHRISTINE I HAAS A00 3978 01/01/1965 PRES 18 F 08/24/1933 52750.00 1000.00 4220.00
000020 MICHAEL L THOMPSON B01 3476 10/10/1973 MANAGER 18 M 02/02/1948 41250.00 800.00 3300.00
000030 SALLY A KWAN C01 4738 04/05/1975 MANAGER 20 F 05/11/1941 38250.00 800.00 3060.00

3 record(s) selected.

SQL1024N A database connection does not exist. SQLSTATE=08003

上面的输出说明,执行最后一条DB2命令时出错,这和AIX上rsh的行为有关。为避免这个错误,可以简单地在rsh命令后面加上一台操作系统命令。例如在命令最后加上echo命令,这样最后一条DB2命令将被成功执行:
rsh hostname ". /home/db2inst1/sqllib/db2profile;db2 connect to sample; db2 \"select * from db2inst1.employee fetch first 3 rows only\";db2 connect reset; echo"

Database Connection Information

Database server = DB2/6000 7.2.0
SQL authorization ID = DB2INST1
Local database alias = SAMPLE

EMPNO FIRSTNME MIDINIT LASTNAME WORKDEPT PHONENO HIREDATE JOB EDLEVEL SEX BIRTHDATE SALARY BONUS COMM
------ ------------ ------- --------------- -------- ------- ---------- -------- ------- --- ---------- ----------- ----------- -----------
000010 CHRISTINE I HAAS A00 3978 01/01/1965 PRES 18 F 08/24/1933 52750.00 1000.00 4220.00
000020 MICHAEL L THOMPSON B01 3476 10/10/1973 MANAGER 18 M 02/02/1948 41250.00 800.00 3300.00
000030 SALLY A KWAN C01 4738 04/05/1975 MANAGER 20 F 05/11/1941 38250.00 800.00 3060.00

3 record(s) selected.

DB20000I The SQL command completed successfully.





http://www.100c.com.cn/oblog/user1/1/index.html
顶部
 



当前时区 GMT+8, 现在时间是 2008-8-30 10:45
乐悠LoveUnix论坛-京ICP备05005823号

Thanks to Discuz!  © 2001-2007    Power by LoveUnix.net
Processed in 0.063225 second(s), 6 queries , Gzip enabled

清除 Cookies - 联系我们 - 乐悠LoveUnix - Archiver