Hi,

i would like to know how to create Db2 stored procedures through script(command line) in Linux.

I have taken the sample script from the db2 help and tried to execute in linux using

db2 connect to sample (it was connected successfully) then

db2 -td@ -vf netcase.db2

the system has thrown the error stating " reached end of file"

So, can anyone tell me how to execute this script in Linux version.

I have Db2 v8.1 and red hat linux 8.1

Also can anyone tell me how to create stored procedures when there are many say like 200-300.

Is it possible to execute all the scripts at a time.

Any help is appreciated.

Sri