#!/bin/sh
DBSCHEMA="VASS2"
exec_sql()
{
db2 connect to dmdata
db2 set schema=$DBSCHEMA
echo $1
_exec=`db2 -x $1`
_exec_result=$?
echo $_exec_result
if [ $_exec_result -ne 0 ] && [ $_exec_result -ne 1 ]
then
echo "sql执行失败:$_exec"
return 1
else
return 0
echo "执行成功"
fi
}
create_table()
{
_exec_sql_value=`exec_sql "create table tab_$1(phone_num varchar(15)) not logged initially compress yes"`
_exec_sql_result=$?
echo ${_exec_sql_value}
if [ ${_exec_sql_result} -ne 0 ]
then
return 1
else
echo "执行成功"
return 0
fi
}
create_table "45678" ---通过create_table直接调用exec_sql函数
exec_sql "create table tab_45678(phone_num varchar(15)) not logged initially compress yes" ----直接调用
执行结果第一个create_table "45678" 报错，报DB2链接不存在
第二个exec_sql可以执行成功
执行结果：
Database Connection Information Database server = DB2/LINUXX8664 9.7.7 SQL authorization ID = CPCDATA Local database alias = DMDATA DB20000I The SQL command completed successfully. create table tab_45678(phone_num varchar(15)) not logged initially compress yes 4 sql执行失败:DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL1024N A database connection does not exist. SQLSTATE=08003
Database Connection Information
Database server = DB2/LINUXX8664 9.7.7
SQL authorization ID = CPCDATA
Local database alias = DMDATA
DB20000I The SQL command completed successfully.
create table tab_45678(phone_num varchar(15)) not logged initially compress yes
0
