Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    38

    Question Unanswered: Recompiling DB2 Stored Procedures

    Is there a way to recompile DB2 stored procedures under AIX platform, without dropping / recreating them ?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I don't think there's a way ...

    Anyway, if you tell why you wish to do this, people may be able to suggest alternate solutions

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jun 2004
    Posts
    38

    Unhappy

    Well, I'm working on remote server and it takes lot of time to drop & build it so after making any modifications in code I've to go thru the whole process so I thought of any alternavtive.

    Please suggest me some alternative way for this.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    If you have made modifications in your code, then AFAIK, you will have to drop and create the SPs ...

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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