Hi,

I just wonder why the unload tools from INFORMIX doesn't unload all required file to every output of mOutFile at the accumulative way OR my script has an error ? In fact it just unload to one single record at the latest.

for mFile in x???
do
  echo "Now working with file "$mFile" at "`date`
  mOutFile=$mFile".unl"
  while read mLine
  do
    _customer_t=$(echo $mLine | cut -d "|" -f 1)
    echo "unload to $mOutFile select cust_num from customer where customer_t=$_customer_t;" | dbaccess demo
  done < $mFile
done

I think you are overlaying $mOutFile.

    echo "unload to tmpfile select cust_num from customer where customer_t=$_customer_t;" | dbaccess demo
    
    cat tmpfile >>$mOutFile