-879   CREATE or ALTER STATEMENT FOR object-name CANNOT DEFINE A COLUMN, DISTINCT TYPE, FUNCTION OR STORED PROCEDURE PARAMETER AS MIXED OR GRAPHIC WITH ENCODING SCHEME encoding-scheme

Explanation

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 TYPE statement cannot define a distinct type, on EBCDIC or ASCII data, with a source type of character FOR MIXED DATA, or GRAPHIC, VARGRAPHIC, or DBCLOB, when the MIXED DATA installation option is set to NO.
  • Start of changeA CREATE FUNCTION or CREATE PROCEDURE statement cannot define a parameter or specify a RETURNS data type, for ASCII or EBCDIC data, as character FOR MIXED DATA, GRAPHIC, VARGRAPHIC, or DBCLOB, when the MIXED DATA installation option is set to NO.End of change

This error occurs only when the encoding scheme that is in use is EBCDIC or ASCII. The MIXED DATA installation option does not affect Unicode data.

This error can occur when a column or parameter is not explicitly defined with FOR MIXED DATA. This situation occurs when the MIXED value in the application defaults module is YES. In this case, the default subtype for character types is FOR MIXED DATA.

System action

The statement cannot be processed.

Programmer response

Contact your system administrator to properly set up the installation options, or change the data types of the elements in columns in your CREATE or ALTER statement.

SQLSTATE

53095