Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008

    Unanswered: Dropping SP implicittly after rename the table

    Hi I am facing one issue in db2 9.7.7 (Window) not tried on linux. When I rename the table all dependent stored procedure(in which any DML operation is being performed) are being dropped implicittly.

    But in DB2 9.5 its works fine without any issue.

    Please help to resolve it.

    Pawan Kumar

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    how verified ? status should become invalid - have never seen an sp to be dropped implic.
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

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