stored procedure on os390

[ingresman]

Hello,

Sorry to be a bit thick but I've got to look at stored procedures on our os390 mainframe.

I'm used to writing procs in pl/sql under Oracle, SQLServer Ingres etc. So I'm a little concerned that I will have to write the procedures in COBOL (or whatever). The issue is the software house we want to use don't have COBOL skills and we don't use C or Java etc.

Just one final thing I have to be able to access the procedure via DB2/Connect.

Is this true do I have to use a high level language ???.

We are on version 7

Many Many thanks in advance

 

[sathyarams]

You can write SQL Procs on os/390 db2 ..

You can begin by looking at the CREATE PROCEDURE Statement in SQL Reference

Cheers

sathyaram

More DB2 questions answered at

http://www.dbforums.com/f8