Ansicht
Dokumentation

SQL0451 - Attributes of parameter &1 not valid for procedure or function &3 in &4. ( OS/400 )

TXBHW - Original Tax Base Amount in Local Currency   Addresses (Business Address Services)  
This documentation is copyright by IBM.


Message : SQL0451
Attributes of parameter &1 not valid for procedure or function &3 in &4.

Message Long Text :

Cause . . . . . : The data type, length, or value of parameter &1 is not valid for the language specified for procedure or function &3 in &4. The parameter name is &2. A list of conditions for the parameters follows:
-- For C: NUMERIC is not a valid data type.
-- For C++: NUMERIC and DECFLOAT are not valid data types.
-- For PL/I: NUMERIC, BIGINT, DECFLOAT, GRAPHIC, VARGRAPHIC, CLOB, BLOB, DBCLOB, and XML are not valid data types.
-- For COBOL: precision for DECIMAL or NUMERIC cannot be greater than 18. FLOAT, DECFLOAT, GRAPHIC, BIGINT, VARGRAPHIC, CLOB, BLOB, DBCLOB, and XML are not valid data types.
-- For ILE COBOL: precision for DECIMAL or NUMERIC cannot be greater than 18. DECFLOAT is not valid.
-- For REXX: SMALLINT, BIGINT, NUMERIC, DECFLOAT, Unicode graphic, CLOB, BLOB, DBCLOB, and XML are not valid data types. FLOAT is not valid if the precision is from 1 to 24. Precision for DECIMAL cannot be greater than 63.
-- For ILE RPG: DECFLOAT is not a valid data type.
-- For RPG: FLOAT, DECFLOAT, BIGINT, VARCHAR, VARBINARY, GRAPHIC, VARGRAPHIC, CLOB, BLOB, DBCLOB, ROWID, and XML are not valid data types.
-- For CL: BIGINT, NUMERIC, VARCHAR, VARBINARY, FLOAT, DECFLOAT, GRAPHIC, VARGRAPHIC, CLOB, BLOB, DBCLOB, and XML are not valid data types. GENERAL WITH NULLS cannot be specified for CL.
-- DataLinks are not valid data types for parameters unless the routine is an SQL procedure or function.
-- LOBs with AS LOCATOR are not valid data types for parameters of an SQL procedure or function.
-- XML AS must be specified for the XML data type for external routines.
Recovery . . . : Correct the data type or precision specified for the parameter on the DECLARE PROCEDURE, CREATE PROCEDURE, ALTER PROCEDURE, CREATE FUNCTION, or ALTER FUNCTION statement. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


CPI1466 during Backup   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.

Length: 3278 Date: 20240420 Time: 102927     sap01-206 ( 3 ms )