Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determining SP Status via DML

Status
Not open for further replies.
dhecht

dhecht

MIS
Aug 6, 1999
41
US
Using z/OS DB2 V6., I need to determine if a stored procedure is stopped or started by running DML. I can't locate a status-type column in SYSROUTINES. Where is DB2 getting this information when a DSN -DISPLAY PROCEDURE command is issued?

Thanks.
 
Status
Not open for further replies.

Similar threads

Ams16
  • Locked
  • Question
Get rows without a specific date
Replies
2
Views
120
johnherman
johnherman
bibulous
  • Locked
  • Question
Concatenate multiple cursor results Into one row using SPUFI
Replies
0
Views
128
bibulous
bibulous
Pack10
  • Locked
  • Question
Windows 7 with DB2 via ODBC? Any issues
Replies
4
Views
95
papadba
papadba
JohnYingling
  • Locked
  • Question
SPUFI: LOCATE ERROR LINE
Replies
1
Views
198
papadba
papadba
GSW2012
  • Locked
  • Question
Batch Spufi Question
Replies
2
Views
114
GSW2012
GSW2012

Part and Inventory Search

Sponsor

Back
Top