-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