Thursday, October 27, 2011

Automatic revalidation in DB2:


Automatic revalidation is a mechanism whereby database objects that a have been invalidated (for example, after a DROP statement) undergo revalidation automatically.

The following list shows the data definition language (DDL) statements for which automatic revalidation is currently supported:
ALTER MODULE DROP FUNCTION
ALTER MODULE DROP PROCEDURE
ALTER MODULE DROP TYPE
ALTER MODULE DROP VARIABLE
ALTER NICKNAME (altering the local name or the local type)
ALTER TABLE ALTER COLUMN
ALTER TABLE DROP COLUMN
ALTER TABLE RENAME COLUMN
CREATE OR REPLACE ALIAS
CREATE OR REPLACE FUNCTION
CREATE OR REPLACE NICKNAME
CREATE OR REPLACE PROCEDURE
CREATE OR REPLACE SEQUENCE
CREATE OR REPLACE TRIGGER
CREATE OR REPLACE VARIABLE
CREATE OR REPLACE VIEW
DROP FUNCTION
DROP NICKNAME
DROP PROCEDURE
DROP SEQUENCE
DROP TABLE
DROP TRIGGER
DROP TYPE
DROP VARIABLE
DROP VIEW
RENAME TABLE

No comments:

Post a Comment