Ansicht
Dokumentation

SQL0491 - Clause not correct for procedure or function. ( OS/400 )

SQL0491 - Clause not correct for procedure or function. ( OS/400 )

Fill RESBD Structure from EBP Component Structure   CPI1466 during Backup  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL0491
Clause not correct for procedure or function.

Message Long Text :

Cause . . . . . : A clause for CREATE PROCEDURE or CREATE FUNCTION or ALTER PROCEDURE or ALTER FUNCTION is missing or not allowed. The reason code is &1. Reason codes and their meanings are:
1 -- For functions, the RETURNS clause is required.
3 -- For functions, the DBINFO, FINAL CALL, and SCRATCHPAD clauses cannot be specified if the parameter style is JAVA or GENERAL. For procedures, DBINFO cannot be specified unless the parameter style is SQL.
4 -- For functions, GENERAL can only be specified if the EXTERNAL NAME specifies a service program.
5 -- For functions and procedures, parameter style JAVA or DB2GENERAL can only be specified for LANGUAGE JAVA.
6 -- A table function cannot have parameter style JAVA, GENERAL, or GENERAL WITH NULLS.
7 -- For functions and procedures, PROGRAM TYPE MAIN is not allowed for JAVA or REXX. PROGRAM TYPE SUB is only allowed for service programs.
9 -- The CARDINALITY clause is only allowed for table functions.
10 -- For external functions and procedures, LANGUAGE SQL is not allowed and there must not be a routine body.
11 -- For external functions and procedures, CONCURRENT ACCESS RESOLUTION cannot be specified.
Recovery . . . : Add the missing clause or remove the clause that is not allowed. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


CL_GUI_FRONTEND_SERVICES - Frontend Services   PERFORM Short Reference  
This documentation is copyright by IBM.

Length: 3245 Date: 20240329 Time: 105137     sap01-206 ( 2 ms )