In simple words of the scenario.

I have some set of files that are to loaded into a table in parallel

Loading part would be taken care of the Abintio graph. I must develop a script which instructs this graph about how to process the files like wat files to process and how to process by passing on some parameters.

This is the task...

let me explain u much better with an example.

Let have that i have the following files EMP.dat, DEPT.dat, BONUS.dat

I have splited all these files into two. EMP001.dat, EMP002.dat, DEPT001.dat, DEPT002.dat, BONUS001.dat, BONUS002.dat

Now take TO Parameters $Load_batch and $set_time

IF $load_batch ='N' the script should provide the information of the files to be processed (which are EMP.dat, DEPT.dat, BONUS.dat)

IF $load_batch = "y" The script should provide the information of batches (first batch files EMP001.dat, DEPT001.dat, BONUS001.dat; Second Batch EMP002.dat, DEPT002.dat, BONUS002.dat)

$set_time is a parameter defines the time between these batches...

Any ideas on this.

?

#!/bin/sh
CURDIR=/home/user/folder

ls -1 *.dat > $CURDIR/dat_fiels
for i in `cat $CURDIR/dat_fiels`
do
echo $i | cut -d"." -f1 | grep "[0-9]" 1> /dev/null
if [ $? -eq 0 ]
then
echo "splitted file $i"
else
echo "normat file $i"
fi
done


o/p will be :

normat file BONUS.dat
splitted file DEPT001.dat
splitted file DEPT002.dat
splitted file DEPT003.dat
normat file DEPT.dat
splitted file EMP001.dat
splitted file EMP002.dat
splitted file EMP003.dat
normat file EMP.dat