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
Please advise.. Cheers
Regards,