stored procedure 1

[Guest_imported]

Hi,
I try to create stored procedure in DB2 on OS/390 using SPUFI.
First of all i do no where is sp stored.
If I create sp using SQL statnent I got an error msg.

Thanks, mlm

 

[v0520]

There is a thing called stored procedure builder which I have not tried yet.
We write all of our stored procedures in cobol.
The interface to the stored procedure environment is in sysibm.sysprocedures. Gilbert M. Vanegas
Programmer Analyst III
County of San Bernardino - ISD
Email : gvanegas@isd.sbcounty.gov

 

[dhecht]

Here's a link concerning creating stored procedues:

http://publibz.boulder.ibm.com/cgi-...x=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

Starting with V6, Stored Procedures are associated with SYSROUTINES.SYSPARMS. SYSROUTINEAUTH, SYSSCHEMAAUTH. SYSPROCEDURES is not supported.

 

[dhecht]

Also, prior to V6, you can use SPUFI to INSERT into SYSPROCEDURES. You'll need authorities to do this.

INSERT INTO SYSIBM.SYSPROCEDURES
VALUES (
'RZ0001SP' ,
' ' ,
' ' ,
'RZ0001SP' ,
' ' ,
'RZTD' ,
'COBOL' ,
0 ,
' ' ,
'N' ,
' ' ,
' ' ,
0 ,
' ' ,
'M' ,
'N' ,
'N'
)

The loadlib where your loadlib is located will need to be concatenated in the SPAS (stored procedure address space) startup deck. Lastly, IBM recommends that you use the NODYNAM compile option. If this isn't the shop standard, put a CBL NODYNAM as the first card in your source deck.

 

[oldcoboler]

You might try QMF if you have it at your installation instead of SPUFI for a stored procedure.