Re: get parameter from unix shell pgm

In its easiest form, try this:

$ yourshell.sh user1 pword1 host.sid

In your shell, refer to the parameters as $1 $2 and $3:

sqlplus $1/$2@$3

or you can save the arguments in variables like

wuser=$1
wpass=$2
whost=$3

and then accordingly:

sqlplus $wuser/$wpass@$whost

Hope this helps!

GRPronet <grpronet_at_aol.com> wrote in article <19971103042100.XAA13639_at_ladder02.news.aol.com>...
> i need to read in parameters coming in from a unix shell pgm.
> (username,password,host string) into sqlplus. how do i do it?
> gil.
>
  Received on Wed Nov 05 1997 - 00:00:00 CST