Need to call stored procedure from unix script

Shell Programming and Scripting
1

Hi Guys,

I have a stored procedure which has 5 out parameters. I need to call the stored procedure from the script.

When i use the following in my script,

db2 "CALL FCFM.PART_MASTER_TMP($Return_code,$Message,$Message1,$SQL,$Load_count)" >> $LOG_FILE

I am getting an error..

Please help me guys..

Thanks for ur help in advance.

Magesh.

2

guys just forgot to mention.. its a db2 stored procedure