Menu principal                 [Fechar]


SQL - SQLCODE's - Códigos negativos


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por Carlos Alberto Dornelles - Analista de Sistemas - Brasília DF.


SQLCode -160

THE WITH CHECK OPTION CANNOT BE USED FOR THE SPECIFIED VIEW

Conclusão: 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.