-874   THE ENCODING SCHEME SPECIFIED FOR THE object-type MUST BE THE SAME AS THE CONTAINING 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

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

SQLSTATE

53091