MVSFORUMS.com

[schintala]

I have create following DB2 SQL procedure on z/os. It created successfully. I am not able to locate the procedure in catalog tables like SYSIBM.SYSROUTINES or SYSIBM.SYSPARMS tables. I wonder where this procedure definition store in catalogs on z/os. Is it different from cobol procedures. Any ideas. My SQL as follows. We are in DB2 V8

SET CURRENT SQLID = 'I581G';

CREATE PROCEDURE UPDRUGS
(IN DMUMNEM CHAR(8)
,IN DOSAGE DECIMAL(5, 2)
)
RESULT SETS 0
MODIFIES SQL DATA
EXTERNAL NAME UPDRUGS
NO DBINFO
WLM ENVIRONMENT TDB2SID1
STAY RESIDENT NO
COLLID ICVPC
PROGRAM TYPE MAIN
RUN OPTIONS 'TRAP(OFF),RPTOPTS(OFF)'
COMMIT ON RETURN NO
LANGUAGE SQL
UPDATE IDVPCS01.ITORDSET
SET DOSE = DOSE * DOSAGE
WHERE MNEMONIC = DMUMNEM;