Ansicht
Dokumentation
CPD3240 - REPLACE SQL VIEW REQUEST IS NOT VALID. ( OS/400 )
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up TXBHW - Original Tax Base Amount in Local CurrencyThis documentation is copyright by IBM.
Message : CPD3240
REPLACE SQL VIEW REQUEST IS NOT VALID.
Message Long Text :
CAUSE . . . . . : SQL VIEW &1 IN LIBRARY &2 WAS BEING REPLACED. THE REPLACE REQUEST COULD NOT BE COMPLETED BECAUSE OF REASON CODE &5. THE REASON CODES AND THEIR MEANINGS ARE AS FOLLOWS:
01 - THE NEW VIEW DEFINITION FOR &1 REFERENCES SQL VIEW OR SQL MATERIALIZED QUERY TABLE &3 IN LIBRARY &4 WHICH IS DEPENDENT ON THE SQL VIEW &1. THIS DEPENDENCY RESULTS IN A CIRCULAR DEPENDENCY, WHICH IS NOT VALID FOR SQL VIEW NETWORKS.
02 - SQL VIEW &1 IN LIBRARY &2 HAS COLUMN LEVEL AUTHORITIES, AND SQL VIEWS THAT HAVE COLUMN LEVEL AUTHORITIES CANNOT BE REPLACED.
03 - THE NEW VIEW DEFINITION FOR &1 IS ATTEMPTING TO BE CREATED OVER FILE &3 IN LIBRARY &4, BUT FILE &3 DOES NOT HAVE ANY MEMBERS. SQL VIEWS CANNOT BE CREATED OVER A FILE WITH NO MEMBERS.
RECOVERY . . . : DO ONE OF THE FOLLOWING BASED ON THE REASON CODE SHOWN, AND THEN TRY THE REQUEST AGAIN:
01 - EITHER MODIFY THE SELECT STATEMENT FOR THE SQL VIEW &1 TO REMOVE THE CIRCULAR DEPENDENCY OR SPECIFY ANOTHER NAME FOR SQL VIEW &1.
02 - SPECIFY ANOTHER NAME FOR SQL VIEW &1.
03 - ADD A MEMBER TO FILE &3 IN LIBRARY &4 (ADDPFM).
Message File : QCPFMSG
Library Message File : QSYS2924
General Material Data General Material Data
This documentation is copyright by IBM.
Length: 3232 Date: 20240424 Time: 161850 sap01-206 ( 3 ms )
