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

FOR UPDATE CLAUSE SPECIFIED FOR READ-ONLY SCROLABLE CURSOR USING cursor-name

Conclusão: A cursor was declared read-only with the INSENSITIVE SROLL option, but the SELECT statement contained a FOR UPDATE clause.

cursor-name Name of the cursor used for the FETCH.

Ação do sistema: The statement cannot be processed.

Resposta do Desenvolvedor: To define a scrollable cursor that is read-only, specify INSENSITIVE SCROLL, but do not specify FOR UPDATE clause. To define a scrollable cursor that can be updated, specify SENSITIVE SCROLL. Corect the application program to DECLARE CURSOR appropriately.

SQLSTATE: 42620


© Copyright IBM Corp.