hi stephen,
You can do this by writing a shell script. I have done this by loading =
multiple infiles
at commnad line.=20
usage $junk_load.sh a.ctl b.ctl c.ctl
----------junk_load-----
SPOOLFILE=3D/tmp/junk_load.$$ =20
INFILES=3D$* =20
DDAT=3D$$.`date "+%Y%m%d"` =20
LOGFILE=3D/tmp/ctel_load.$DDAT =20
CTLFILES=3D`ls -1 $INFILES 2>/dev/null` =20
=20
if [ ! "$CTLFILES" ] =20
then =20
echo "ERROR. $INFILES not found." =20
echo "$0 cancelled at `date`" =20
exit 1 =20
fi =20
=20
#More than one file could be found, so process all of them.
for i in $CTLFILES =20
do =20
echo "Processing $i..." =20
sqlload userid=3Dscott/tiger control=3D$i data=3Ddata1.txt silent=3Dheade=
r,feedback errors=3D10000 bad=3D/tmp/$i.bad log=3D/tmp/$i.log=20
done
echo "$0 completed at `date`" =20
Received on Tue Jul 11 2000 - 18:06:50 CDT
