| View previous topic :: View next topic |
| Author |
Message |
schintala
Beginner
Joined: 18 May 2005
Posts: 108
Topics: 31
Location: USA
|
 Posted: Tue Mar 31, 2009 2:07 pm Post subject: DB2 SQL Procedure Catalog |
 |
|
I have created the following DB2 SQL procedure on z/os. It created succesfully. But I am unable to locate in DB@ catalog tables like SYSIBM.SYSROUTINES/SYSPARMS tables. I wonder where these definiton store? Any ideas? Is it different for SQL procedures from COBOL procedures in z/os environment. We are in version DB2 V8. My sql as follows.
| Code: |
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; |
|
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Tue Mar 31, 2009 4:00 pm Post subject: |
|
|
schintala,
How did you create the SP? did you do it via SPUFI? If so make sure that Auto Commit is SET to YES on the options panel in spufi
Kolusu |
|
| Back to top |
|
|
schintala
Beginner
Joined: 18 May 2005
Posts: 108
Topics: 31
Location: USA
|
| Posted: Wed Apr 01, 2009 8:32 am Post subject: |
|
|
| Thank you for the reply. It was my error. My spufi panel did not set properly. I corrected it now after your reply. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
