疑难杂正症

warmcool

#!/bin/sh
if [ $# != 3 ]
then
        exit
fi

eid=$1
sid=$2
sd=$3
if [ ${eid} -eq x ]
then
${eid}="%"
fi

if [ ${sid} -eq x ]
then
${sid}="%"
fi

${SYBASE}/isql -Uuser -Pusertest -SUSER_SERVER <<!
drop table user_err_${eid}_${sid}_${sd}
go
create table user_err_${eid}_${sid}_${sd}(
sid varchar(10) null,
did varchar(10) null,
svid varchar(20) null,
rtime varchar(20) null
)
go
!

if [ ${sd} -eq x ]
then

for num in 5 6 8 9
do
        ${SYBASE}/isql -Uuser -Pusertest -SUSER_SERVER <<!
        delete from user_err_${eid}_${sid}_${sd}
        go
        insert into user_err_${eid}_${sid}_${sd}
        select sid,
        did,
        svid,
        rtime
        from SPSM_ERROR_DETAIL${num}
        where eid like '${eid}' and left(sid,4) like '${sid}'
        go
        !
        ${SYBASE}/bcp user_err_${eid}_${sid}_${sd} out ${sid}_${eid}_${num}.txt -Uuser -Pusertest -SUSER_SERVER -c -t"|"
done
else
    ${SYBASE}/isql -Uuser -Pusertest -SUSER_SERVER <<!
    insert into user_err_${eid}_${sid}_${sd}
    select sid,
    did,
    svid,
    rtime
    from USER_ERROR${sd}
    where eid like '${eid}' and left(sid,4) like '${sid}'
    go
    !
    ${SYBASE}/bcp user_err_${eid}_${sid}_${sd} out ${sid}_${eid}_${sd}.txt -Uuser -Pusertest -SUSER_SERVER -c -t"|"
fi

${SYBASE}/isql -Uuser -Pusertest -SUSER_SERVER <<!
    drop table user_err_${eid}_${sid}_${sd}
    go
!
------------------------------------------------
一直报最后一行“`文件结束' 非期望的”

[ 本帖最后由 warmcool 于 2007-1-10 10:51 编辑 ]

Edengundam

使用<<EOF
EOF
要顶行写...另外用!不太好吧......

warmcool

${sid}="%"  这个好像也不对

warmcool

搞定了，谢谢Edengundam (Eden)    风云使者