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

SENSITIVITY sensitivity SPECIFIED ON THE FETCH IS NOT VALID FOR CURSOR cursor-name

Conclusão: The sensitivity option specified on FETCH conflicts with the sensitivity option in effect for cursor cursor-name. If a cursor is declared INSENSITIVE, the FETCH statement can only specify INSENSITIVE or nothing. If a cursor is declared SENSITIVE, the FETCH statement can specify INSENSITIVE, SENSITIVE, or nothing.

sensitivity Specified sensitivity for the FETCH statement.

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

In case of a non-scrollable cursor, sensitivity option cannot be specified.

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

Resposta do Desenvolvedor: Change the host variable to be an exact numeric with a scale of zero.

SQLSTATE: 42618


© Copyright IBM Corp.