Helpful Information
Home
Categories
Contact us
Category: DB2 Development
how to create Db2 stored procedures through script
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
privacy (GDPR)