Menu principal                 [Fechar]


SQL - SQLCODE's - Códigos negativos


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por Carlos Alberto Dornelles - Analista de Sistemas - Brasília DF.


SQLCode -148

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.