Using DB2, can I check when a stored procedure was modified?

I see that some versions of MSSQL allow you to run a query to retrieve information about stored procedures. I also saw the same type of query for Oracle. Is there anything similar for DB2?

Specifically, I am hoping to be able to see when a stored procedure was created and/or last modified.

Thank you!

Answers


This should be what you are looking for:

select routinename, create_time, alter_time from syscat.routines where routinetype='P'

Yes, You can check in DB2 when stored procedure is modified. Please find below Query for the same. Don't confuse for CREATE_TIME this means last modified time.

Code as below:

SELECT PROCNAME, CREATE_TIME FROM SYSCAT.procedures WHERE PROCNAME = '<>' order by CREATE_TIME desc

Note: Replace <> with your actual stored procedure name.


Need Your Help

Flowplayer: Clicking on the player forces is to reload

flowplayer

I've got this damn annoying bug (or wrong setting) that makes the player reload whenever it's clicked. It's set to play when you click, so when you click it, it reloads. The circle begins....

jax-rs, jersey archetype, can't seem to use @WebListener

java web-services rest maven jax-rs

I'm trying to launch a background task at the start of a restful service. However I can't seem to use neither @WebListener nor @Schedule. I thought it was a servlet version problem but it's the first