- 论坛徽章:
- 220
|
本帖最后由 lz小骆驼 于 2014-08-04 12:14 编辑
- #!/bin/sh
- path1="/home/appuser/totalaccount"
- echo "TotalAccount.sh Is start" >>$path1/log2.txt
- echo "db2 connect to mphisdb" >>$path1/log2.txt
- db2 connect to mphisdb user mphisdb using Mphisdb_13
- echo "connect db ok" >>$path1/log2.txt
- echo "export organid:redmum total start" >>$path1/log2.txt
- db2 "export to $path1/1.txt of del modified by coldel, SELECT count(*), (sum(cast(tr_amt as bigint))*0.01)
- FROM mphisdb.IMBTRADEWATER
- where src_mcht_cd='990340148160000' and sys_date='20140701' and ANS_CODE1='00'"
- echo "export organid:1 total end" >>$path1/log2.txt
- echo "db2 quit" >>$path1/log2.txt
- db2 quit
- echo "db2 terminate" >>$path1/log2.txt
- db2 terminate
- echo "TotalAccount1.sh Is end" >>$path1/log2.txt
复制代码 刚开始学写脚本,上周写了一个脚本,跑的时候正常。其中有一行- path1=/home/appuser/totalaccount
复制代码 今天又写了一个测试脚本,两个脚本基本相同,却一直报- No such file or directoryhome/appuser/totalaccount
复制代码 经检查path1路径确实存在,
这是什么原因呢 ?新手大求神指点。 |
|