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

    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.

    Thanks

    - Raj

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    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
  •