Ansicht
Dokumentation

CPD43A1 - The query with data change table reference cannot be run. ( OS/400 )

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.


Message : CPD43A1
The query with data change table reference cannot be run.

Message Long Text :

Cause . . . . . : The target of data change table reference &1 in library &2 is not valid for reason code &3. The reason codes and their meanings follow:
1 -- The view has an INSTEAD OF trigger defined.
2 -- The view contains a function that is not deterministic, or has external action, or modifies SQL data in its where clause.
3 -- The view or its underlying view contains a scalar subselect, or scalar fullselect, or subquery.
4 -- The logical file is a select/omit, or join logical file.
5 -- A distributed file is used as data change table reference.
Recovery . . . :
-- If the view has an INSTEAD OF trigger specified, then remove the INSTEAD OF trigger and try the operation again.
-- Functions that are not deterministic, or have external action, or modify SQL data cannot be used in the where clause of views as the target of data change reference.
-- If a view, or its underlying view contains a scalar subselect, or fullselect. or subquery, then the view cannot be used as the target of data change table reference.
-- Select/omit, or join logical file cannot be used as the target of data change table reference.
-- A distributed file cannot be used as the target of data change table reference.
Change the SQL statement and try the operation again.

Message File : QCPFMSG
Library Message File : QSYS2924


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

Length: 3261 Date: 20240418 Time: 045625     sap01-206 ( 3 ms )