|
A tabela fonte source-name não pode ser renomiada ou alterada
Conclusão: Possible cases:
- 1 The RENAME statement cannot be used to rename a view, an
active RLST table, or a table for which a synonym is defined.
- 2 The ALTER statement cannot be used to alter the length of the column because the column is
referenced in a referential
integrity relation, a user exit (field procedure, edit procedure, valid procedure, stored procedure or user defined function), a global temporary table,
or a table defined with data capture changes. If the table name specified in the alter is a view or if there exists a row in SYSVIEWDEP that has
source-name as a base table name, then this ALTER statement will fail.
Ação do sistema: O comando não pode ser executado.
Resposta ao Desenvolvedor: For case:
- 1 Drop all views, inactivate the RLST table, or drop the synonym.
- 2 Avoid referential integrity relations, user exits, or global temporary
tables.
- 3 Run REORG INDEX, REORG TABLESPACE, or REBUILD INDEX. If the
index is partitioned, then run the utility on
all the partitions. Reissue the statement.
SQLSTATE: 42809
© Copyright IBM Corp.
|