Ansicht
Dokumentation

CPD3103 - OPTION(*INP) required for other parameter values specified. ( OS/400 )

CPI1466 during Backup   Vendor Master (General Section)  
This documentation is copyright by IBM.


Message : CPD3103
OPTION(*INP) required for other parameter values specified.

Message Long Text :

Cause . . . . . : The file must be opened only for input operations if the query specifications require one of the following:
-- Join processing where multiple files were specified on the FILE parameter.
-- Unique key processing where the UNIQUEKEY parameter was specified.
-- The sum of the key fields is to exceed 2000 bytes.
-- A SQL view that has distinct processing is to be queried.
-- A SQL view is to be queried that references the same table as the table of the outer-most subselect.
-- A copy of the data to perform the requested functions.
The *INP value OPTION parameter is also required if group processing is required because of the use of the GRPFLD parameter, or the GRPSLT parameter, or an aggregate function (%MIN or %MAX with only one argument, %AVG, %COUNT, %SUM, %STDDEV, or %VAR).
For more information about SQL views, 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/ or the DB2 for i5/OS SQL programming topic collection in the Database category in the IBM i Information Center book, http://www.ibm.com/systems/i/infocenter/.
Recovery . . . : Do one of the following and try the request again:
-- Omit the OPTION parameter.
-- Specify the *INP value for the OPTION parameter.
-- Omit the specifications that limit the open query file to input processing.

Message File : QCPFMSG
Library Message File : QSYS2924


General Data in Customer Master   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3263 Date: 20240427 Time: 042424     sap01-206 ( 3 ms )