Ansicht
Dokumentation

SQL0604 - Attributes not valid. ( OS/400 )

CL_GUI_FRONTEND_SERVICES - Frontend Services   CPI1466 during Backup  
This documentation is copyright by IBM.


Message : SQL0604
Attributes not valid.

Message Long Text :

Cause . . . . . : One of the following contains a data type, length, precision, scale, or an ALLOCATE attribute that is not valid.
-- A column in the CREATE TABLE, ALTER TABLE, or DECLARE GLOBAL TEMPORARY TABLE statement, or an INCLUDE column in an INSERT statement.
-- A parameter or an SQL variable in the DECLARE PROCEDURE, CREATE PROCEDURE, ALTER PROCEDURE, CREATE FUNCTION, ALTER FUNCTION, or CREATE TRIGGER statement.
-- The CAST scalar function.
-- A CREATE TYPE source data type.
-- A CREATE VARIABLE data type.
The definition is not valid for one of the following reasons:
-- If a DECIMAL or NUMERIC data type is specified, precision must be from 1 through 63 and the scale must be between 0 and the precision.
-- If DECFLOAT is specified, the precision must be omitted or must be 16 or 34.
-- If CHARACTER or BINARY is specified, the length must be from 1 through 32766 for a parameter or for a column that does not allow null values or from 1 through 32765 for a column that allows null values.
-- If VARCHAR or VARBINARY is specified, the length must be from 1 through 32740 for a parameter or for a column that does not allow null values or from 1 through 32739 for a column that allows null values.
-- If the FOR MIXED DATA clause or a mixed CCSID is specified, the length cannot be less than 4.
-- If GRAPHIC or NCHAR is specified, the length must be from 1 through 16383 for a parameter or for a column that does not allow null values and from 1 through 16382 for a column that allows null values. The length specified is the number of DBCS characters.
-- If VARGRAPHIC or NVARCHAR is specified, the length must be from 1 through 16370 for a parameter or for a column that does not allow null values or from 1 through 16369 for a column that allows null values. The length specified is the number of DBCS characters.
-- If BLOB or CLOB is specified, the length must be from 1 through 2G (2048 M or 2,097,152 K or 2,147,483,647 bytes). If DBCLOB or NCLOB is specified, the length must be from 1 through 1073741823.
-- If DATALINK is specified, the length must be from 1 through 32717.
-- If VARCHAR, VARGRAPHIC, NVARCHAR, VARBINARY, CLOB, BLOB, DBCLOB, NCLOB, or DATALINK is specified the ALLOCATE attribute must be less than or equal to both the length attribute specified and 32766.
-- DATALINK and arrays cannot be specified as the type of a global variable.
-- ARRAY¬0| cannot be specified on CREATE TYPE.
Recovery . . . : Correct the length, precision, scale, or ALLOCATE attribute. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


ROGBILLS - Synchronize billing plans   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.

Length: 3239 Date: 20240426 Time: 072226     sap01-206 ( 3 ms )