Aviso importante


  C. A. Dornelles

SQL - SQLCODE's - Códigos positivos - +339


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 +339

   
 
  • Causa
    • THE SQL STATEMENT HAS BEEN SUCCESSFULLY EXECUTED, BUT THERE MAY BE SOME CHARACTER CONVERSION INCONSISTENCIES

      The application is connected to a DB2 Version 2 Release 3 database server.
      The SQL statement is using an alias or three-part name, which refers to another DB2 subsystem that is at the Version 2 Release 2 level.
      DB2 Version 2 Release 2 does not support character conversion.
      Since the execution of SQL statements from an EBCDIC DRDA requester to an EBCDIC Version 2 Release 2 DB2 server could require character conversion, a warning is generated.
      If the requester system CCSID is inconsistent with the DB2 Version 2 Release 2 environment, most EBCDIC character code points match to the same character.
      Only certain special characters typically lead to data integrity concerns.
      Therefore, a warning is generated.
  • Ação do sistema
    • The statement is successfully executed.
  • Resposta ao Desenvolvedor
    • If the DB2 Version 2 Release 2 table is accessed from other environments (different CCSID), incorrect results might occur (relative to what the other environment might expect).
      You should understand what characters might not be consistent with the DB2 Version 2 Release 2 environment (its inherent CCSID) and avoid use of those characters or understand the exposure you face if you use them.

      If the application must refer to the Version 2 Release 2 subsystem data, the Version 2 Release 2 DB2 subsystem can be migrated to Version 2 Release 3 where character conversion is supported.

      SQLSTATE: 01569