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


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 -733
   
 
  • Causa
    • THE DESCRIPTION OF A TABLE SPACE, INDEX SPACE, OR TABLE IN A ROSHARE READ DATABASE MUST BE CONSISTENT WITH ITS DESCRIPTION IN THE OWNER SYSTEM

      This code is issued while creating a table space, index, or table in the ROSHARE READ database.
      These objects must be consistent with their descriptions in the ROSHARE OWNER database as follows:

      • For a table space, the following attributes must be the same:

        • Page size
        • Segment size
        • Number of partitions

      • For an index, the following attributes must be the same:

        • Number of partitions
        • Number of subpages
        • Table OBID
        • Total key length
        • Index type (Type 1 or Type 2 Index)
        • Number of key columns

      • For a table, the following attributes must be the same:

        • Table OBID
        • Maximum record length
        • Number of columns
        • Whether an edit procedure exists
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Ensure that the definition of the table space, index, or table is consistent with that in the ROSHARE OWNER database.

      SQLSTATE: 56056
© Copyright IBM Corp.