We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

CPD431A - SQL view &1 in &2 not allowed. Reason code &3. ( OS/400 )

CPD431A - SQL view &1 in &2 not allowed. Reason code &3. ( OS/400 )

BAL_S_LOG - Application Log: Log header data   PERFORM Short Reference  
This documentation is copyright by IBM.
SAP E-Book


Message : CPD431A
SQL view &1 in &2 not allowed. Reason code &3.

Message Long Text :

Cause . . . . . : Structured Query Language (SQL) view &1 in library &2 cannot be queried because of reason code &3. The reason codes and their meanings follow:
1 -- The query has specified a distinct result. The SQL view and the query cannot both have distinct results.
2 -- A distinct SQL view cannot be joined with another file.
3 -- Not all of the fields being returned are fields from the SQL view. The query must return all fields of the SQL view without changing any field attributes. No derived fields are allowed to be returned.

Message File : QCPFMSG
Library Message File : QSYS2924


rdisp/max_wprun_time - Maximum work process run time   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.

Length: 3232 Date: 20201020 Time: 225525     sap01-206 ( 1 ms )