- 论坛徽章:
- 0
|
- dbaccess sffdb <<!
- Unload to sf31.unl
- Select ksdm From sf31
- Where ksdm <> '00000000'
- And grade = 'H'
- AND ksdm[5,8]="0000"
- order by 1
- !
- sed -e "s/|//g" sf31.unl > sf31_tmp.unl
- sed '$a\
- 43000000
- ' sf31_tmp.unl > sf31_tmp1.unl
- rm sf31_tmp.unl
- mv sf31_tmp1.unl sf31.unl
- echo "aaa"
- for com in `cat sf31.unl`
- do
- echo "$com"
- cname=`dbaccess surveydb@hn5912bak<<!
- select comcname from prpdcompany where comcode="$com";
- !`
- echo "$cname"
- sleep 1
- str="bz ALLX B C CCX CHX E G HK HNX J JDCX JQCX NX Q QT SYCX W Y YJX Z ZBX"
- for bz in $str
- do
- echo "$bz"
- dbaccess surveydb@hn5912bak<<!
- !echo "$com"
- !echo "$cname"
- !echo "$bz"
- insert into bb03(surveydate,comcode,comcname,bz)
- values("20100831","$com","$cname","$bz");
- !
- done
- done
复制代码 我在执行到
insert into bb03(surveydate,comcode,comcname,bz)
values("20100831","$com","$cname","$bz");
的时候报错,
282: Found a quote for which there is no matching quote.
Error in line 2
Near character position 34
我通过打印
"$cname"
的发现到
dbaccess surveydb@hn5912bak<<!
!echo "$com"
!echo "$cname"
!echo "$bz"
insert into bb03(surveydate,comcode,comcname,bz)
values("20100831","$com","$cname","$bz");
!
这里的时候cname已经没有值了,大家可以给我分析一下原因么 |
|