从数据库取得数据来启动程序的示例

#!/bin/bsh

export logfile=${HOME}/log/qhsock.`date +"%Y%m%d%H%M%S"`.log

TMPPORT=`dbaccess - - <<! 2>>${logfile}
    database $DATABASE;
    select trim(chnl_code),trim(class_code),trim(serv_port),trim(tux_service),flag_set[2],msglen_width,timeout from c_member_ip where chnl_code='CQJS';
    close database;
!`

##echo $TMPPORT >> ${logfile}

count=1
for Tpara in $TMPPORT
do
    exc=`expr $count % 14`
    if [ $exc -eq 0 ]
    then
        para=$para" "$Tpara
        echo $para |awk '{print "qhsock " $2 " " $4 " " $6 " " $8 " " $10 " " $12 " " $14}' >>$logfile 2>&1
        echo $para |awk '{cmd="qhsock " $2 " " $4 " " $6 " " $8 " " $10 " " $12 " " $14 ">>$logfile 2>&1";system(cmd)}'
        para=""
    else
        para=$para" "$Tpara
    fi

    count=`expr $count + 1`
done