最近做的一个小工具用到了在Shell中访问DB2和Sybase中的存储过程,特记录下来备查。 Shell中访问DB2: DB2="/opt/IBM/db2/V9.5.FP2/bin/db2" DB_NAME="DB1" USER="user" PASSWORD="pass123" SP_NAME="ABC.GET_STATUS" #connect to db2 CONN_RESULT=`$DB2 connect to $DB_NAME user $USER using $PASSWORD` if [ $? -ne 0 ] then echo $CONN_RESULT exit 1 fi $DB2 "call $SP_NAME" | sed '1,7d;/^$/,$d'| while read TABLE ROWS do echo "$TABLE $ROWS" done $DB2 connect reset