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


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 -620

   
 
  • Causa
    • KEYWORD keyword IN stmt type STATEMENT IS NOT PERMITTED FOR A space type SPACE IN THE database type DATABASE

      The specified keyword in the SQL statement stmt type indicates an attribute that is not allowed for a space type space in the database type database.
      keyword
      Specifies the keyword that is not allowed.
      stmt type
      CREATE or ALTER
      CREATE is for CREATE TABLESPACE or CREATE INDEX.
      ALTER is for ALTER TABLESPACE or ALTER INDEX.
      space type
      TABLE or INDEX
      TABLE is for table space, and INDEX is for index space.
      database type
      WORK FILE or TEMP
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Refer to DB2 SQL Reference for information about attributes that are allowed or not allowed for a space type space in a database type database.
      Correct and resubmit the stmt type statement.

      SQLSTATE: 53001

© Copyright IBM Corp.