Shell执行DB2 SQL
#!/usr/bin/env sh
DBNODE='nodename'
DBUSER='username'
DBPASSWORD='password'
connDB2()
{
if( db2 connect to $1user $2 using $3 > /dev/null )
then
echo 'OK'
else
echo "failed connect to ${DBNODE}"
exit -1
fi
}
releaseDB2(){
db2 connect reset> /dev/null
}
run(){
connDB2 ${DBNODE} ${DBUSER} ${DBPASSWORD}
sql="
select
area_id ,areaname
from
pt.area
"
db2 -x ${sql}| while read area_id areaname
do
echo "Result:${area_id}->${areaname}"
done
releaseDB2
}
echo "execute sql ................."
run
如果有必要可以通过执行完SQL后$?的结果来判断是不是执行成功
if [ "$?" -ne "0" ]
then echo "execute error"
exit -1
fi
下面是DB2文档中找到的返回值的含义
The return code can be one of the following:
Code Description
0 DB2 command or SQL statement executed successfully
1 SELECT or FETCH statement returned no rows
2 DB2 command or SQL statement warning
4 DB2 command or SQL statement error
8 Command line processor system error
页:
[1]