SQL - SQLCODE's - Códigos negativos -148


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -148
   
 
  • Causa
    • A tabela fonte source-name não pode ser renomeada ou alterada.

      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.