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

THE SQL STATEMENT IN AN EXTERNAL FUNCTION, TRIGGER, OR IN STORED PROCEDURE name VIOLATES THE NESTING SQL RESTRICTION

Conclusão: If a table is being modified (by INSERT, DELETE or UPDATE), the table can not be accessed by the lower level nesting SQL statement.

If any table is being accessed by a SELECT statement, no table can be modified (by INSERT, DELETE or UPDATE) in any lower level nesting SQL statement.

Ação do sistema: The SELECT, INSERT, DELETE or UPDATE SQL statement failed.

Resposta ao Desenvolvedor: Remove the failing statement from the named external function, trigger or the stored procedure.

SQLSTATE: 57053


© Copyright IBM Corp.