Ansicht
Dokumentation
SQL0491 - Clause not correct for procedure or function. ( OS/400 )
Fill RESBD Structure from EBP Component Structure CPI1466 during BackupThis documentation is copyright by IBM.
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 )