Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
When trying to Alter existing Stored Procedure a Create or Replace DDL is generated instead
설명
When trying to ALTER an existing Stored Procedure, Toad generates complete CREATE PROCEDURE DDL instead of a simple ALTER statement.
원인
EXTERNAL procedures in z/OS are not supported for native ALTER.
해결 방안
Support for a native ALTER is implemented in z/OS for Native SQL procedures only. Toad is working as designed and there are currently no plans to support it on EXTERNAL procedures.