RENAME TABLE field (RENAMETABLE subsystem parameter)
The RENAMETABLE subsystem parameter specifies whether RENAME TABLE issues an error or allows the operation when RENAME TABLE is issued for a table that is referenced in a view definition or the definition of an SQL table function.
| Acceptable values: | DISALLOW_DEP_VIEW_SQLTUDF, ALLOW_DEP_VIEW_SQLTUDF |
|---|---|
| Default: | DISALLOW_DEP_VIEW_SQLTUDF |
| Update: | option16 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM RENAMETABLE |
- DISALLOW_DEP_VIEW_SQLTUDF
- Db2 issues an error when RENAME TABLE is issued for a table that is referenced in the definition of a view or an SQL table function.
- ALLOW_DEP_VIEW_SQLTUDF
- Db2 does not issue an error when RENAME
TABLE is issued for a table that is referenced in the definition of a view or an SQL table
function.
When a RENAME TABLE statement is issued for such a table, the Db2 database manager takes the following actions:
- Updates internal information about object dependencies, but does not change the text representations of statements that created or altered views or routines that depend on the renamed table in the SYSIBM.SYSVIEWS or SYSIBM.SYSROUTINES catalog tables.
- Invalidates statements that refer to the table that is renamed
In a data sharing environment, specify the same value of RENAMETABLE for all members.