topic Re: script help in Operating System - HP-UX

script help

Sanjiv Sharma_1 — Fri, 16 Apr 2004 01:03:15 GMT

Hi,

I want to have a script. The funtion of this script is to check a list of database names from a text file and then execute another 3 numbers scripts(available with me) for each of the names.

Text file:
DB1
DB2
DB3
DB4
etc...

My new script should read DB1 first and then execute about 3 more scripts.
Then it reads DB2 and execute the same three scripts and so on till the last DB.

Thanks,

Re: script help

KapilRaj — Fri, 16 Apr 2004 01:06:44 GMT

for DBASE in `cat textfile`
do
case $DBASE in
DB1) scr1,scr2,scr3 ;;
DB2) scr4,scr5,scr6 ;;
...
..
esac
done

Is this what u need ?

Kaps

Re: script help

Vijaya Kumar_3 — Fri, 16 Apr 2004 01:09:23 GMT

create a text file named testfile

then this piece of code will do:

###BEGIN SCRIPT
for i in `cat testfile`
do
/myscript1 $i #Execute Script1
/myscript2 $i #Execute Script2
/myscript3 $i #Execute Script3
done
###END SCRIPT

Here i am passing the values as parameters to the script.

Hope this helps
vj

Re: script help

Sanjiv Sharma_1 — Fri, 16 Apr 2004 01:16:45 GMT

It is not very clear to me.
Lets be more specific:

Text filename is testfile.
Contents of the file is
DB1
DB2
DB3
etc...

My three scripts are :
/home/oracle/scripts/a.sh
/home/oracle/scripts/b.sh
/home/oracle/scripts/c.sh

Thanks,

Re: script help

Vijaya Kumar_3 — Fri, 16 Apr 2004 01:22:32 GMT

$ cat testfile
DB1
DB2
DB3
...
$

Then the script is mine.sh

$ cat mine.sh
###BEGIN SCRIPT
for i in `cat testfile`
do
/home/oracle/scripts/a.sh
/home/oracle/scripts/b.sh
/home/oracle/scripts/c.sh
done
###END SCRIPT
$
$ ksh mine.sh

it will do what you want

Hope this helps
Vijay

Re: script help

Vijaya Kumar_3 — Fri, 16 Apr 2004 01:24:47 GMT

I really dont understand why are you running these without a need for DB1,DB2 values.

Generally, you may need this value inside the script.

Can u please tell what are you going to do with Db1,Db2 etc , inside the script.

Vijay

Re: script help

V.Tamilvanan — Fri, 16 Apr 2004 01:34:28 GMT

Hi sanjiv,
This below script should help you.

for DBASE in `cat testfile`
do
case $DBASE in
DB1) /home/oracle/scripts/a.sh ;;
DB2) /home/oracle/scripts/b.sh ;;
DB3) /home/oracle/scripts/c.sh ;;
esac
done

Re: script help

Sanjiv Sharma_1 — Fri, 16 Apr 2004 01:40:25 GMT

Hi Vijaya,

Yes. Maybe I wat not clear.
I want the tree script to run on DB1 and then on DB2 and so on..

What should we need to change on your given script to incorporate this?

Re: script help

V.Tamilvanan — Fri, 16 Apr 2004 01:41:59 GMT

Hi sanjiv,
The earlier one was for a single script . but the below one for multiple scripts.

for DBASE in `cat testfile`
do
case $DBASE in
DB1) /home/oracle/scripts/a.sh; /home/oracle/scripts/b.sh; /home/oracle/scripts/c.sh ;;
DB2) .................;;
DB3) .................;;

esac
done

HTH.

Re: script help

KapilRaj — Fri, 16 Apr 2004 01:46:31 GMT

Are you done sanjiv ?. Actually i did not really uinderstand ur requirement !

Kaps

Re: script help

Sanjiv Sharma_1 — Fri, 16 Apr 2004 01:52:38 GMT

I believe Tamil's second response should work.

I will get back after testing it.

Thank you all.