maximum number of input file to fastload

Tools & Utilities
Enthusiast

maximum number of input file to fastload

Hi,

Please tell me how many number of input files can be defines in a single fastload job and how?

Regards
2 REPLIES
Enthusiast

Re: maximum number of input file to fastload


Unless something interesting has happened in recent times, it was one input file per load job and the trick to load multiple files was to submit multiple fastload jobs serially with different file names without specifying the end loading command. the end loading command is to be specified only on the last fastload job.

To make things a little easy to develop and maintain, folks used to write scripts which took filename as argument for loading multiple files, and there would be another script (or code segment) which always "touched" an empty file (in other words zero records) and invoked a fastload job with "end loading" included in the job script.
Enthusiast

Re: maximum number of input file to fastload

Also unix guys make use of named fifos to load multiple files in one shot

it goes something like this (not a very neat code ;) )

#create the fifo
mkfifo -m 600 $HOME/work/myfif

# combine all files and write to fifo (do it in background)
cat file1.dat file2.dat > $HOME/work/myfif &

# store the above processe's pid
cpid=$!

# this is the fast load latin
fastload <<EOF

......fast load code goes here .....
specify $HOME/work/myfif as the input file

EOF

# capture fastload's return code
rc=$?

if [[ $rc -ne 0 ]]
then
# if fastload messed up, terminate the background process
kill $cpid
fi

# wait for any background processing to be over
wait