Posted: Mon Nov 03, 2003 11:13 am Post subject: how to create db2 stored procedures through script file

--------------------------------------------------------------------------------

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 through a single script file,also are there any options if i want to create all the scripts in a new database server from existing database server.

Any help is appreciated.

Sri

Hi Sri,

You can download the below Redbooks from www.redbooks.ibm.com

Cross-Platform DB2 Stored Procedures: Building and Debugging SG24-5485-01

Setup of the DB2 Application Development Environment for Stored Procedures, REDP-0183-00

Up and Running with DB2 for Linux, SG24-6899-00

I don't know much about DB2 application development however I am sure these would help you in your quest.

Regards

Nitin.

Hi nitin,

I have taken the example from the db2 help only, still it is throwing errors when i run it.

Also, i am looking for something where i can execute all the procedures at a time in a single script.

Any ideas..