最近做的一个小工具用到了在Shell中访问DB2和Sybase中的存储过程,特记录下来备查。 Shell中访问Sybase: ISQL="/opt/sybclient-12.5/bin/isql" DB_NAME="DEV2" USER="testdbo" PASSWORD="111" SP_NAME="dbo.get_status" #connect to sybase RESULT=`$ISQL -w 1000 -U$USER -P$PASSWORD -S$DB_NAME<<EOF use dbtest go exec $SP_NAME go exit EOF` echo "$RESULT" | sed '1,2d;/^$/,$d' | while read TABLE ROWS STATE do echo "$TABLE $ROWS" | tr '[a-z]' '[A-Z]' done