Ansicht
Dokumentation

CPD439D - User-defined function usage not valid. ( OS/400 )

General Material Data   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.


Message : CPD439D
User-defined function usage not valid.

Message Long Text :

Cause . . . . . : Specified user-defined function &3 in library &2 is not allowed in the context in which it is used for reason code &1. The reason codes and their meanings follow:
1 -- The function is used in a GROUP BY expression and an index is required to perform the grouping.
2 -- The function is used in an ORDER BY expression and an index is required to perform the ordering.
3 -- The function is used in a join query such that an index is required to perform the join.
4 -- The function is referenced in a check constraint.
5 -- The function is a table function and must be a scalar or column function.
6 -- The function is a scalar or column function and must be a table function.
7 -- The function was found in ASP group &4 while creating a view or a materialized query table in ASP group &5.
8 -- The function is used in a PARTITION BY or ORDER BY expression for an OLAP specification where NOT DETERMINISTIC and EXTERNAL ACTION user-defined functions are not allowed.
Recovery . . . : Refer to 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/ for more information on user-defined functions. For reason codes 1, 2 or 3, change the allow copy data option to either ALWCPYDTA(*OPTIMIZE) or ALWCPYDTA(*YES). For reason code 4, remove the reference to the user-defined function. For reason codes 5 and 6, specify the right type of function for the context in which it is referenced. For reason code 7, verify that the function is in the correct ASP group and the SQL path is set correctly. Try the request again.

Message File : QCPFMSG
Library Message File : QSYS2924


Vendor Master (General Section)   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.

Length: 3236 Date: 20240425 Time: 022416     sap01-206 ( 3 ms )