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


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 -4730
   
 
  • Causa
    • INVALID SPECIFICATION OF XML COLUMN table-name.column-name IS NOT DEFINED IN THE XML VERSIONING FORMAT, REASON reason-code.

      The indicated column is not valid in the context specified.
      The column must be defined in the XML versioning format.
      table-name
      The name of the table.
      column-name
      The name of the column.
      reason-code
      The reason for the message or SQL code, indicated by one of the following values:
      1
      The target of the SET assignment clause containing the XMLMODIFY function invocation is a column that is not XML in the versioning format.
      The target of an assignment involving an invocation of the XMLMODIFY function must be an XML column that is in the XML versioning format.
      2
      A SELECT FROM UPDATE or SELECT FROM DELETE statement specified OLD TABLE, and referenced an XML column that is not defined in the XML versioning format.
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Correct the syntax, and reissue the statement.
      1
      Change the SET assignment clause to specify an XML column that is defined in the XML versioning format, or remove the XMLMODIFY function in the assignment clause.
      2
      Change the column specified in the SELECT FROM UPDATE or SELECT FROM DELETE statement to specify an XML column that is defined in the XML versioning format.
      SQLSTATE: 55079
© Copyright IBM Corp.