Ansicht
Dokumentation

SQL0514 - Prepared statement &2 not found. ( OS/400 )

BAL_S_LOG - Application Log: Log header data   CPI1466 during Backup  
This documentation is copyright by IBM.


Message : SQL0514
Prepared statement &2 not found.

Message Long Text :

Cause . . . . . : An attempt was made to open cursor &1 which referred to prepared statement &2. Statement &2 has one of the following conditions:
-- The statement has never been prepared.
-- The statement was prepared in another program or another call of this program and the program was created with CLOSQLCSR(*ENDPGM).
-- The statement was prepared in another module or another call of this module and the module was created with CLOSQLCSR(*ENDMOD).
-- The statement was prepared in another call of this program and programs which have run SQL statements have ended and the program was created with CLOSQLCSR(*ENDSQL).
-- The statement was prepared in another call of this module and the activation group ended between calls. The module was created with CLOSQLCSR(*ENDACTGRP).
-- A COMMIT or ROLLBACK statement has destroyed all the prepared statements.
Recovery . . . : Do one of the following and precompile again:
-- Prepare the statement &2 (PREPARE statement) before attempting to open cursor &1.
-- Make certain that &2 has been prepared in the same program or module call prior to attempting to open cursor &1 or specify either CLOSQLCSR(*ENDSQL) CLOSQLCSR(*ENDJOB), or CLOSQLCSR(*ENDACTGRP) when precompiling the application.
-- If the statement was deleted by a COMMIT or ROLLBACK, specify HOLD on the COMMIT or ROLLBACK statement to preserve any open cursors, prepared statements, and locks on tables.

Message File : QSQLMSG
Library Message File : QSYS2924


Addresses (Business Address Services)   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.

Length: 3232 Date: 20240424 Time: 153855     sap01-206 ( 2 ms )