Ansicht
Dokumentation

CPD3157 - JDFTVAL and file &1 in &2 not compatible. ( OS/400 )

General Data in Customer Master   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.


Message : CPD3157
JDFTVAL and file &1 in &2 not compatible.

Message Long Text :

Cause . . . . . : If logical file &1 in library &2 is a join logical file, then JDFTVAL(*NO) is required if the join logical file was created without the JDFTVAL Data Description Specifications (DDS) keyword, and JDFTVAL(*YES) is required if the join logical file was created using the JDFTVAL DDS keyword. All join logical files specified on the FILE parameter must either have been created with the JDFTVAL DDS keyword, or all the files must have been created without the JDFTVAL DDS keyword. If logical file &1 in library &2 is a Structured Query Language (SQL) view, then JDFTVAL(*NO) is always required.
See the CL topic collection in the Programming category in the IBM i Information Center book, http://www.ibm.com/systems/i/infocenter/, for more information about compatible JDFTVAL parameter values.
See the DB2 for IBM i SQL Reference topic collection in the Database category in the IBM i Information Center book, http://www.ibm.com/systems/i/infocenter/, for more information about SQL views.
Recovery . . . : Either specify a JDFTVAL parameter value on the OPNQRYF command that is compatible with the join or SQL view, or replace the join or SQL view with its based-on physical files (FILE parameter) and specify the necessary additional join fields on the JFLD parameter. Then try the request again.

Message File : QCPFMSG
Library Message File : QSYS2924


BAL_S_LOG - Application Log: Log header data   Addresses (Business Address Services)  
This documentation is copyright by IBM.

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