Ansicht
Dokumentation

SQL7918 - Reusable ODP deleted. Reason code &1. ( OS/400 )

CPI1466 during Backup   General Material Data  
This documentation is copyright by IBM.


Message : SQL7918
Reusable ODP deleted. Reason code &1.

Message Long Text :

Cause . . . . . : An existing Open Data Path (ODP) was found for this statement, but it could not be reused for reason &1. The statement now refers to different files or uses different override options than are in the ODP. Reason codes and their meanings are:
1 -- Commitment control isolation level is not compatible.
2 -- The statement contains SQL special register USER, CURRENT DEBUG MODE, CURRENT DECFLOAT ROUNDING MODE, or CURRENT TIMEZONE, and the value for one of these registers has changed.
3 -- The PATH used to locate an SQL function has changed.
4 -- The job default CCSID has changed.
5 -- The library list has changed, such that a file is found in a different library. This only affects statements with unqualified table names, when the table exists in multiple libraries.
6 -- The file, library, or member for the original ODP was changed with an override.
7 -- An OVRDBF or DLTOVR command has been issued. A file referred to in the statement now refers to a different file, library, or member.
8 -- An OVRDBF or DLTOVR command has been issued, causing different override options, such as different SEQONLY or WAITRCD values.
9 -- An error occurred when attempting to verify the statement override information is compatible with the reusable ODP information.
10 -- The query optimizer has determined the ODP cannot be reused.
11 -- The client application requested not to reuse ODPs.
Recovery . . . : Do not change the library list, the override environment, or the values of the special registers if reusable ODPs are to be used.

Message File : QSQLMSG
Library Message File : QSYS2924


ROGBILLS - Synchronize billing plans   PERFORM Short Reference  
This documentation is copyright by IBM.

Length: 3242 Date: 20240420 Time: 014225     sap01-206 ( 2 ms )