SQL - SQLCODE's - Códigos positivos - +653


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 +653

   
 
  • Causa
    • TABLE table-name IN PARTITIONED TABLESPACE tspace-name IS NOT AVAILABLE BECAUSE ITS PARTITIONED INDEX HAS NOT BEENCREATED

      An attempt has been made to insert or manipulate data in or create a view on a partitioned table (that is, a table residing in a partitioned table space) before the partitioned index for that table has been created.

      A table residing in a partitioned table space cannot be referenced in any SQL manipulative statement or a CREATE VIEW statement before the partitioned index for that table has been created.
  • Ação do sistema
    • A valid plan or package will be created if no errors are detected.
      The statement is bound dynamically on each execution of the statement.
  • Resposta ao Desenvolvedor
    • For better performance, rebind the plan or package after correcting the statement.
      To correct the statement, verify that the correct table was specified in the statement.
      If so, ensure that the partitioned index for the table has been created successfully before attempting to execute any SQL manipulative statements that reference that table.

      SQLSTATE: 01551