| |
- Causa
- CREATE or ALTER STATEMENT FOR obj-name CANNOT DEFINE A COLUMN, DISTINCT TYPE, FUNCTION OR STORED PROCEDURE PARAMETER AS MIXED OR
GRAPHIC WITH ENCODING SCHEME encoding-scheme
A CREATE or ALTER TABLE statement for object-name attempted to define a column, distinct type, or parameter of a user-defined function
or stored procedure as mixed data or graphic when the system does not have an appropriate CCSID defined for the encoding-scheme
encoding scheme.
- A CREATE, with CCSID UNICODE clause specified, cannot be processed because the proper level of OS/390 is not installed.
Refer to the Program Directory for information on the level of OS/390 required for UNICODE support.
- A CREATE DISTINCT TYPE statement cannot define a distinct type, on EBCDIC or ASCII data, with a source type of CHAR FOR MIXED DATA, or
GRAPHIC, VARGRAPHIC, or DBCLOB, when the MIXED DATA install option is set to NO.
- A CREATE FUNCTION or CREATE PROCEDURE statement cannot define a parameter or specify a RETURNS data type, for ASCII or EBCDIC data, as
CHAR FOR MIXED DATA, or GRAPHIC, VARGRAPHIC, or DBCLOB, when the MIXED DATA install option is set to NO.
Nota: This error only occurs when the encoding scheme in use is EBCDIC or ASCII. The MIXED DATA install option does not affect Unicode data.
Nota: This error can occur when there is an attempt to define a column or parameter as character FOR MIXED DATA even though the keywords FOR
MIXED DATA do not appear in the failing statement.
This occurs when the MIXED value in DECP is YES, in this case the default subtype for the character types is FOR MIXED DATA.
- Ação do sistema
- The statement cannot be processed.
- Resposta ao Desenvolvedor
- Contact your system administrator to properly setup the installation options, or change the data types of the elements in columns in your CREATE
or ALTER statement.
SQLSTATE: 53095
© Copyright IBM Corp.
|
| |
