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


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 -721
   
 
  • Causa
    • BIND ERROR FOR PACKAGE = pkg-id CONTOKEN = contoken'X IS NOT UNIQUE SO IT CANNOT BE CREATED.

      An attempt is made to add or replace a package with a consistency token that is not unique for that package.
      In other words, the combination of location.collection.package.consistency-token already exists.
      pkg-id
      Fully qualified name of the package.
      contoken
      Consistency token in hexadecimal.
  • Ação do sistema
    • The BIND will fail.
  • Resposta ao Desenvolvedor
    • Check the SYSIBM.SYSPACKAGE catalog table for names of existing application packages with the indicated consistency token.
      Reissue the BIND subcommand such that the location.collection.package.consistency-token is unique within the catalog.
      The following SQL statement can be used to query the catalog: 
      
                 SELECT COLLID,NAME>
                 FROM   loc-id.SYSIBM.SYSPACKAGE
                 WHERE  HEX(CONTOKEN) = contoken
      SQLSTATE: 42710
© Copyright IBM Corp.