Determinng SP Status via DML 
Author Message
 Determinng SP Status via DML
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.



Mon, 18 Jul 2005 10:34:26 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Microdata Spooler Manager (SP-STATUS/SP-JOBS)

2. SQL DMO - Determinng database Size from dump

3. How do I get a return status from an SP into DTS

4. Query/SP to check merge replication status?

5. Status of a SP

6. Monitor status of a job from a SP

7. Testing Return Status of SQL SP using VB

8. Return status of SP

9. Checking status of SP?

10. SP completion status....

11. Not displaying ret. status of SP

12. Displaying status of each SQL Job via ASP


 
Powered by phpBB® Forum Software