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


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

   
 
  • Causa
    • THE WITH CHECK OPTION CANNOT BE USED FOR THE SPECIFIED VIEW

      The WITH CHECK OPTION does not apply to a view definition under either of the following circumstances:
      • The view is read-only (for example, the view definition includes DISTINCT GROUP BY, or JOIN).
      • The view definition includes a subquery.
  • Ação do sistema
    • The statement cannot be executed.
      The specified view was not created.
  • Resposta ao Desenvolvedor
    • Refer to Chapter 5 of DB2 SQL Reference for rules regarding use of the WITH CHECK OPTION in view definitions.

      SQLSTATE: 42813

© Copyright IBM Corp.