Ansicht
Dokumentation

CPD43AE - Materialized query table not valid. ( OS/400 )

rdisp/max_wprun_time - Maximum work process run time   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.


Message : CPD43AE
Materialized query table not valid.

Message Long Text :

Cause . . . . . : Field or value &1 is not valid in a materialized query table query for reason code &6 when enable query optimization is specified. The reason codes and their meanings follow:
1 -- The field contains a reference to a function that is defined to have external action, or a function that is not deterministic.
2 -- The field contains a reference to a special register.
3 -- The field or value is from view &4 in &5 which contains an item that is not valid.
4 -- The field contains a reference to a global variable.

The materialized query table is &2 in library &3.

Message File : QCPFMSG
Library Message File : QSYS2924


General Material Data   General Material Data  
This documentation is copyright by IBM.

Length: 3227 Date: 20240424 Time: 172717     sap01-206 ( 3 ms )