Aviso importante
Caso tenhas alguma
dúvida a respeito
da linguagem mande
um e-mail que terás
a resposta.
  C. A. Dornelles

SQL - SQLCODE's - Códigos positivos


Volta a página anterior

Volta ao Menu Principal


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

SQLCode +110
SQL UPDATE TO A DATA CAPTURE TABLE NOT SIGNALED TO ORIGINATING SUBSYSTEM

Causa:
DataPropagator (DPropNR) exit routine issued an SQL INSERT, UPDATE, or DELETE statement to a table defined with DATA CAPTURE CHANGES. Since data capture is already in progress, notification is not sent back to the originating IMS subsystem.

Ação do sistema:
DB2 changes the data and records the change in the log. DB2 does not notify DPropNR's exit routine of the change, because doing so might cause the same change to be made again.

SQLSTATE: 01561