Ansicht
Dokumentation

SQL7009 - &1 in &2 not valid for operation. ( OS/400 )

Vendor Master (General Section)   CPI1466 during Backup  
This documentation is copyright by IBM.


Message : SQL7009
&1 in &2 not valid for operation.

Message Long Text :

Cause . . . . . : The reason code is &3. Reason codes are:
1 -- A materialized query table that was deferred when it was restored cannot be refreshed using REFRESH TABLE or altered using ALTER TABLE.
2 -- The target of a data change table reference is a distributed file.
3 -- Distributed table &1 exists on the requester system but does not exist on the target system.
4 -- Field procedure &1 in &2 failed.
5 -- Service program &1 in &2 is not a global variable.
Recovery . . . : Do one of the following based on the reason code:
1 -- Ensure the materialized query table's based-on files and their members are available. Then save and restore the deferred materialized query table using the Save Object (SAVOBJ) and Restore Object (RSTOBJ) commands.
2 -- Specify a data change table reference that is not a distributed file.
3 -- Specify a different table that exists on the requester and target systems.
4 -- Ensure the field procedure is valid.
5 -- Specify a different variable, or delete the service program associated with the variable &1 in &2 and recreate the global variable.

Message File : QSQLMSG
Library Message File : QSYS2924


Vendor Master (General Section)   General Material Data  
This documentation is copyright by IBM.

Length: 3235 Date: 20240420 Time: 183515     sap01-206 ( 3 ms )