I ran into a situation where I need to retrive all the user defined stored procedures from the DB2 database. Here's the scenario => I have a DB2 database v7.2 on AIX where all the stored procedures are created and functioining properly. I have performed a redirected restore of this database on to a new one. Now I need to run the stored procedures on this newly created database. Unfortunately I lost the stored procedures source code. Is there a way that I can retrieve the stored procedures in a source code format by any chance. Please let me know if there are any options.

Thanks

- Raj

I use the attached Windows command file to extract SP source code. I'm sure you will be able to easily convert it into a shell script