Pinned topicWhere did my SQL external procedure go?

‏2013-09-24T21:22:45Z
|Tags:

Answered question
This question has been answered.

Unanswered question
This question has not been answered yet.

We have several RPG programs that are exposed to Java clients as SQL external procedures. Ocassionally, the SQL procedure is dropped when the external program object is changed by our change management software. We suspected the change managment system was responsible but that idea was eliminated since it does not manage the procedure DDL.

Will DB2 for i automatically drop an SQL external procedure if the high level language program object it calls is changed?