Aviso importante


  C. A. Dornelles

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


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

   
 
  • Causa
    • DB2 CONVERTED A HOST VARIABLE, PARAMETER, OR COLUMN NUMBER var-num var-name-or-num TO COLUMN NAME, HOST VARIABLE, OR EXPRESSION NUMBER col-name-or-num FROM from ccsid TO to-ccsid, AND RESULTING IN SUBSTITUTION CHARACTERS.

      A conversion error occurred during the conversion of a string to a different coded character set.
      One or more substitution characters have been placed in the string during the conversion process.

      var-num var-name-or-num
      The value of the host variable, the parameter, or the column number prior to the conversion process.
      This value might be the string *N if the column number is not available when this SQLCODE is issued.
      col-name-or-num
      The value of the host variable, the parameter or the column number after the conversion process.
      This value might be the string *N if the column number is not available when this SQLCODE is issued.
      from ccsid
      The input CCSID for the host variable, parameter, or column number.
      to-ccsid
      The resulting CCSID from the conversion of the host variable, parameter, or column number.
  • Ação do sistema
    • Db2® processes the statement successfully.
  • Resposta ao Desenvolvedor
    • This warning can occur in two situations:

      • If trace for IFCID 136 or 168 is not active, Db2 processes the SQL statement, but used substitution characters instead of one or more characters as a result of character conversion from from ccsid to to-ccsid.
        If substitution is acceptable, no action is necessary. If substitution is not acceptable, issue a ROLLBACK. Ensure that data being provided to Db2 is convertible from from ccsid to to-ccsid without data loss.
      • If trace for IFCID 136 or 168 is active, and the to-ccsid token is an EBCDIC CCSID, and system parameter UIFCIDS is OFF, this warning is caused by the conversion to EBCDIC CCSID for IFCID trace record.
        Use the GET DIAGNOSTICS statement to determine if the there are other warnings associated with the original SQL string. If GET DIAGNOSTICS returns no other warnings, no action is required.

      SQLSTATE: 01517