> Do you mean "the VALID field for this procedure is still marked Y" You said
database)?
Yes
What action-type message did you get with the SQL0727N?
Error: [IBM][CLI Driver][DB2/NT] SQL0727N An error occurred during
implicit system action type "1". Information returned for the error
includes SQLCODE "-206", SQLSTATE "42703" and message tokens "SALARY".
SQLSTATE=56098
The way to reproduce this on the db2 SAMPLE database is:
1. Create BUMP_SALARY sql proc from db2 samples.
2. Drop /rename STAFF table (which BUMP_SALARY references
3. Try to execute the proc.
One workaround I tried was to check if the package for the stored proc
was valid using the following query:
SELECT A.ROUTINESCHEMA, A.ROUTINENAME, B.VALID FROM SYSCAT.ROUTINES A,
SYSCAT.PACKAGES B WHERE SUBSTR(A.IMPLEMENTATION, 1, 8)= B.PKGNAME AND
A.ROUTINESCHEMA=B.PKGSCHEMA