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


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 -107
   
 
  • Causa
    • THE NAME IS TOO LONG. MAXIMUM ALLOWABLE SIZE IS size

      The name is too long. The maximum permissible length for names of that type is indicated by size.
      Names for the following cannot contain more than 128 characters:
      • Savepoint-name

      Names for the following cannot contain more than 64 characters:

      • Version-id

      Names for the following cannot contain more than 18 characters (20 including SQL escape characters, if present):

      • SQL columns
      • SQL tables
      • SQL views
      • SQL indexes
      • SQL aliases
      • SQL synonyms
      • Collection-ids
      • Check constraints
      • Functions
      • Stored procedures
      • User-defined types

      Names for the following cannot contain more than 16 characters:

      • Location-name

      The following cannot contain more than 8 characters:

      • Table qualifiers
      • View qualifiers
      • Library member names specified in an INCLUDE statement
      • Storage group names
      • Database names
      • Table space names
      • Application plans
      • Database request modules (DBRMs)
      • Referential constraint names specified in CREATE or ALTER TABLE statements
      • Package-ids
      • Schema names
      • Trigger names

      Host variable names cannot contain more than 64 characters.
      Volume serial numbers cannot contain more than 6 characters.
      Labels cannot contain more than 30 characters.

  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Choose a shorter name for the object.

      SQLSTATE: 42622

© Copyright IBM Corp.