#!/usr/bin/env sh
DBNODE='nodename'
DBUSER='username'
DBPASSWORD='password'
connDB2()
{
if( db2 connect to $1 user $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
分享到:
相关推荐
DB2数据库SQL注入手册1
DB2 UDB SQL入门,经典
第 1章 – DB2 Express-C是什么?..........................................................................................13 1.1免费开发、部署和分发… 无限制!.............................................
第 1章 – DB2 Express-C是什么?..........................................................................................13 1.1免费开发、部署和分发… 无限制!.............................................
db2star2 INSTANCE:DB2INST1 NODE:000主机名:e12f8d659e14 FUNCTION:DB2 UDB,基部SYS公用事业,DB2StartMain,探针:MESSAGE:ZRC =0xFFFFFB3C=-1220 SQL1220N 数据库管理器未能分配共享内存。 一些标准输出...
mysqldump -uusername -ppassword –databases db1 db2 > db1db2.sql 4、导入某些库 mysql命令行 mysql>source db1db2.sql; 5、导入某个库 系统命令行 mysql -uusername -ppassword db1 < db1
IBMi DB2查询和其他用于IBMi的工具DTASRCSP.sql-按顺序获取存储过程引用的表/程序的列表,该列表/程序出现在作业的库列表中使用DSPPGMREF的输出确定程序对象引用的对象,然后使用存储过程以与库列表中出现的顺序相同...
2. 从另一个shell执行mount vxfs snapshot。 3. 从第一个客户端执行UNLOCK TABLES。 4. 从快照复制文件。 5. 卸载快照。 只创建数据库备份确实创建了一个 DR 解决方案。它也许是非常有限的,这取决于您的环境。通过...
非 IBM 这可用于 DB2 和 informix,我想在 postgresql 数据库上播放它。 结果证明没问题,我也想让其他人更容易。 所以我也添加了mysql方言。也可以看看游戏场景您是一家大型企业安全部门的实习生。 作为培训的一...
ibm.db2connect-win-1.0.2 oderwat.indent-rainbow-7.4.0 ms-vscode-remote.vscode-remote-extensionpack-0.16.0 ms-vscode-remote.remote-ssh-0.45.5 ms-vscode-remote.remote-ssh-edit-0.45.5 ms-vscode-remote....
ibm.db2connect-win-1.0.2 oderwat.indent-rainbow-7.4.0 ms-vscode-remote.vscode-remote-extensionpack-0.16.0 ms-vscode-remote.remote-ssh-0.45.5 ms-vscode-remote.remote-ssh-edit-0.45.5 ms-vscode-remote....
ssh2 — Secure Shell2 Functions Statistics — Statistics Functions Streams — Stream Functions Strings — String 字符串处理函数 SVN — Subversion 函数 SWF — Shockwave Flash Functions swish — Swish ...
ssh2 — Secure Shell2 Functions Statistics — Statistics Functions Streams — Stream Functions Strings — String 字符串处理函数 SVN — Subversion 函数 SWF — Shockwave Flash Functions swish — Swish ...
“ bash数据库”是GNU bash shell的可加载内置命令,它允许使用类似于嵌入式SQL程序中使用SQL命令的脚本来访问关系数据库。 最初是为DB2编写的,现已添加了对数据库的支持
Secure Shell2 Functions CXXIX. Semaphore, Shared Memory and IPC Functions CXXX. SESAM Database Functions CXXXI. Session Handling Functions CXXXII. Shared Memory Functions CXXXIII. Shockwave Flash ...
Secure Shell2 Functions CXXIX. Semaphore, Shared Memory and IPC Functions CXXX. SESAM Database Functions CXXXI. Session Handling Functions CXXXII. Shared Memory Functions CXXXIII. Shockwave Flash ...
Secure Shell2 Functions CXXIX. Semaphore, Shared Memory and IPC Functions CXXX. SESAM Database Functions CXXXI. Session Handling Functions CXXXII. Shared Memory Functions CXXXIII. Shockwave Flash ...
Secure Shell2 Functions CXXIX. Semaphore, Shared Memory and IPC Functions CXXX. SESAM Database Functions CXXXI. Session Handling Functions CXXXII. Shared Memory Functions CXXXIII. Shockwave ...
Secure Shell2 Functions CXXIX. Semaphore, Shared Memory and IPC Functions CXXX. SESAM Database Functions CXXXI. Session Handling Functions CXXXII. Shared Memory Functions CXXXIII. Shockwave Flash ...
Secure Shell2 Functions CXXIX. Semaphore, Shared Memory and IPC Functions CXXX. SESAM Database Functions CXXXI. Session Handling Functions CXXXII. Shared Memory Functions CXXXIII. Shockwave Flash ...