Shell Programming and Scripting

Hi,
I am having a function inside a shell script. The Shell script is called with parameters and one of the parameter is passed to a SQL script inside the function.
But when the function is called inside the shell script, the SQL script is not called.

Do the shell parameter has to be passed to the function inside the shell script.

eg.

a.ksh
[
# /bin/ksh
func()
{
sqlplus -s a.sql $2
}

func
]

$ a.ksh samp a

Please let me know

Thanks in advance.

you should use code tags !

pass all parameters to your function so it can determine $2

Code:

# /bin/ksh
func()
{
     sqlplus -s a.sql $2
}

func $@

That will fail if any of the arguments contain spaces.

Code:

func()
{
     sqlplus -s a.sql "$2"
}

func "$@"

All,
Thanks a lot for your quick response.