db2 delete 大表不写日志方法 - 数据库编程

elete from "$DBSCHEMA"."$TAB_NAME" "
else
v_tx_date=`db2 -x "select date('"$WORK_DATE"') -(int(trim('"$KEEP_DATE"'))*31) days from sysibm.sysdummy1 "`
delete_table="delete from "$DBSCHEMA"."$TAB_NAME" where date("$TAB_DATE") = date('"$v_tx_date"')"
fi
fi
DELDATA=`db2 -a $delete_table`
echo "$DELDATA" | sed -n -e 's/^.*sqlcode: $[-,0-9][0-9]*$.*/\1/p' | read SQLCODE
if [ $SQLCODE -ge 0 ]

then
echo "the job delete table sucessfull"
else
echo "the job delete table false"
fi
fi

done
fi

db2 delete 大表不写日志方法(二)