How to Write Stored Procedure in DB2 OS390

[job1]

Hi All

I am new to DB2. Can anyone help me in writing a Stored Procedure(SP) in DB2 OS390, I tried creating one using Command Center(Please find it pasted below). I am not able to execute it by using the command EXEC NEW_1. Also could anyone tell me whether anything else I had missed out to make this SP work.

CREATE PROCEDURE proc_1() LANGUAGE SQL BEGIN
Select * from employees;
END

Thanks in advance

 

[sathyarams]

You cannot use command centre ...

you will have to use stored proc builder of development centre if you intend to build from the clinet ..

IF you intend to do it on the host itself, it involves translate/precomnpile/compile/linkedit/bind and then creating definition ... Check the application reference guide for details

Cheers
Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp