Shell Programming and Scripting

Set -A _Category="A\
                          B\
                          C"
for _cat in ${_Category}
  do
    sed -e "s:<TABLE_NAME>:${_cat}:g" \
          -e "s:<date>:${_dt}:g" \
          ${_home}/skl/sq1.sql >> ${_dest}/del_${_dt}.sql
    fi
    _seq_cnt=`wc -l ${_dest}/seqlist_${_dt}.lst|awk '{print $1}'`
    if [[ ${_seq_cnt} -gt 999 ]] ; then
         _start=1
         _end=999
         while [[ ${_seq_cnt} -gt 0 ]]
         do
           cat ${_dest}/seqlist_${_dt}.lst|sed  -n "${_start},${_end}p"|awk '{if (NR==1 && substr($0,1,1)==",") {print sub
str($0,2)} else {print $0}}' >> ${_dest}/del_${_dt}.sql
           fi
            ((_seq_cnt =_seq_cnt-999))
            ((_start=_start+999))
            ((_end=_end+999))
            if [[ ${_seq_cnt} -gt 0 ]] ; then
                echo ")"  >> ${_dest}/del_${_dt}.sql
                echo " or  DW_AUTHOP_SEQ_NBR in (" >> ${_dest}/del_${_dt}.sql
             fi
            fi
         done
 echo "));" >> ${_dest}/del_${_dt}.sql

split -l