-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.
- FL 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.
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.
- FL 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.
SQLSTATE
53091