SQL - SQLCODE's - Códigos negativos -392


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -392

   
 
  • Causa
    • SQLDA PROVIDED FOR CURSOR cursor HAS BEEN CHANGED FROM THE PREVIOUS FETCH.

      The application is running with DB2 rules, and has requested that LOB data be returned as a LOB in one FETCH statement, and as a locator in another FETCH statement.
      This is not permitted.
  • Ação do sistema
    • The statement is not executed and the connection is terminated.
  • Resposta ao Desenvolvedor
    • Either do not use DB2 rules, or change to application to not change the data type code from LOB to locator (or the reverse) in the SQLDA between successive fetches.

      SQLSTATE: 42855

© Copyright IBM Corp.