Hi All

i have n files and each file has 5-6 .sql files.Now I need to wrie a shell script that executes all the n files in parellel and for each n file the .sql files sequentially.eg

CRM_File CM_file AP_file

crm_file_1425.sql
cm_file_5789.sql
ap_file_4124.sql
crm_file_1426.sql
cm_file_5788.sql
ap_file_4124.sql
crm_file_1427.sql
cm_file_5787.sql
crm_file_1428.sql

i want to run CRM_File CM_file AP_file in parellel and
each file under CRM_File,CM_file,AP_file sequentially.Please Help and thanx a lot in advance.

I did not get what you exactly needed.
For running scripts parllely , you cannot do any thing in shell script.you can use cronjobs for that.

You can execute sql script in shell script as follows.

/opt/ORACLE/bin/sqlplus batch/databasebatch@DATABASE /data01/scripts/execute.sql


Thanks,
Soma

Hmm... for those you want to run in parallel, why not just use the & symbol?

E. g. to make two BASH scripts run in parallel:

?

nope...i think i did not explain my question clearly.I need to run the CRM ,CM and AP in parellel and all the sqls under each sequentailly.I think i need to create child processes....please help...

Sorry, I still have no idea what you're trying to do there. How do you normally
"run" your CRM, CM and AP files? How do they relate to the sql files (apart from
the obvious names)?



Cheers,
Tink

the ARM,CM etc are module names under which there are n sql files that need to be executed.suppose the ARM module has 5 sql files then these 5 sql files would get executed sequentially but the modules should run in parellel.i have been able to write the script for one module.the sql files are running sequentially but now i ve to make the sql files in other modules run in parellel.i know i can establish it by forking the child process but since i ve just started unix i ve not reached that level.please help.the code written till now is:

#!/bin/sh
#!/usr/bin/awk -f
#export file2="temp_file2"
rm -f temp_file1
rm -f temp_file2
rm -f temp_file3
rm -f file_unique_modules
rm -f *SQL_LIST*
echo -n "Enter directory name:"
read dname


ls -l $dname | grep -v '^d' >> temp_file2

awk '{print $9}' temp_file2 >> temp_file3

while read temp_file3_line
do
string=$temp_file3_line
module_name="$(echo $string | cut -d '_' -f 2)"
echo $module_name >> temp_file1
done <temp_file3

awk '{print $0}' temp_file1 | sort -u >> file_unique_modules

while read module_name

do

file_name="${module_name}_SQL_LIST.sql"
echo $file_name
touch $file_name
done <file_unique_modules

while read temp_file3_line
do
string=$temp_file3_line
module_name="$(echo $string | cut -d '_' -f 2)"
echo $temp_file3_line >> "${module_name}_SQL_LIST.sql"
done <temp_file3
. DBSQLExecute
while read line

do

VAR1=$line
echo calling function
SQL_CONN_CODE="sa/sa@conCRM5"
#. DBSQLExecute
DBSQLExecute $VAR1 $SQL_CONN_CODE
#DBSQLExecute sa sa conCRM5 ARFB_CRM_5106.sql
echo returned from function

the function is as:::::::
#!/bin/sh -vx
echo inside DBSQL
DBSQLExecute()
{
echo value of 1 is $1
echo value of 2 is $2
echo $$ >sql.pid
cd ARFB
#sqlplus -s ${SQL_CONN_CODE} < $1
sqlplus -s $2 < $1
echo connected
sleep 5
}
~
~this code is running 5 .sql files in one module.there are 8 other modules like this and under each module there are 6-9 .sql filesto be run sequentially.i hope i ve been clear.please guide!!!!
~
~

I'm still not sure about that "in parallel" part. You have no guarantee
that the jobs will all run the same time; so it's quite possible that
the list of 6 ARMs completes before the 5th CM has been started.