Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: Retrieving Stored Procedures

    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.


    - Raj

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts