-874 THE ENCODING SCHEME SPECIFIED FOR THE object-type MUST BE THE SAME AS THE CONTAINING OR TARGET TABLE SPACE OR OTHER PARAMETERS

Explanation

A CCSID clause was incorrectly specified in one of the following situations:

  • In a CREATE TABLE or ALTER TABLE statement:
    • CCSID ASCII was specified, and the containing table space is EBCDIC or UNICODE.
    • CCSID EBCDIC was specified, and the containing table space is ASCII or UNICODE.
    • CCSID UNICODE was specified, and the containing table space is ASCII or EBCDIC.
  • In a fullselect that creates a table, the following items were not the same:
    • The encoding scheme of the result table of the fullselect
    • The encoding scheme in the CCSID clause (if specified)
    • The encoding scheme of the target table space
  • In a CREATE TYPE statement for an array, the CCSID clause was specified for the data type of array elements and for the data type of the index. The CCSID specifications for the array elements and for the index were not the same.
  • Start of changeFL 508 In an ALTER TABLESPACE statement with a MOVE TABLE clause, the CCSID attributes of the table space that is being altered (the source table space) were not the same as the CCSID attributes of the target table space.End of change

System action

The statement cannot be processed.

Programmer response

Correct the SQL statement in one of the following ways:

  • For a CREATE TABLE or ALTER TABLE statement, make the CCSID value in the CREATE TABLE or ALTER TABLE statement the same as the CCSID of the containing table space.
  • For a fullselect that creates a table, make all of the following items the same:
    • The encoding scheme of the result table of the fullselect
    • The encoding scheme in the CCSID clause (if specified)
    • The encoding scheme of the target table space
  • For a CREATE TYPE statement for an array, make the CCSID specification for the array elements and for the index the same.
  • Start of changeFL 508 For an ALTER TABLESPACE statement with a MOVE TABLE clause, specify a target table space that has the same CCSID attributes as the source table space.End of change

SQLSTATE

53091