DB2 SQL-Error: -879
SQLState: 53095
Short Description: CREATE ALTER STATEMENT FOR CANNOT DEFINE A COLUMN DISTINCT TYPE FUNCTION OR STORED PROCEDURE PARAMETER AS MIXED OR GRAPHIC WITH 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. v 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. v 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. v 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.Note: This error only occurs when the encoding scheme in use is EBCDIC or ASCII. The MIXED DATA install option does not affect Unicode data. Note: 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.System action: The statement cannot be processed. Programmer response: 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.