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


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

   
 
  • Causa
    • BIND ERROR, ATTEMPTING TO REPLACE PACKAGE = package_name WITH VERSION = version2 BUT THIS VERSION ALREADY EXISTS.

      An attempt is made to create a version of a package that already exists.
      The version specified in the REPLVER keyword is different from the version specified for the precompile.
      The version specified for the precompile already exists in the catalog.
      The combination of 'location.collection.package.version' must be unique in the SYSIBM.SYSPACKAGE catalog table.
      A common mistake is that the user may believe that the version he is creating is the one specified in the REPLVER keyword.
      This is not the case. The version specified in the REPLVER keyword is the name of the version being replaced.
      The version that will be created is the version that was given to the program when it was precompiled.
      package_name
      Fully qualified package name
      version2
      Version-id of package that is to be created
  • Ação do sistema
    • The bind will fail.
  • Resposta ao Desenvolvedor
    • There are two approaches to solve this problem.
      The first is to precompile the program again with a new version name and reissue the original BIND subcommand.
      The other approach is not to do the precompile but reissue the BIND subcommand with REPLVER(SAME).

      SQLSTATE: 42710
© Copyright IBM Corp.