DB2 SQL-Error: -873
SQLState: 53090
Short Description: THE STATEMENT REFERENCED DATA ENCODED WITH DIFFERENT ENCODING SCHEMES OR CCSIDS IN AN INVALID CONTEXT C E SQL INSERT SELECT I V SQL T ASCII EBCDIC UNICODE T DECP CCSID SQL S T P C SQL
The SQL statement referenced data from multiple encoding schemes or CCSIDs in a context where the reference is not allowed. This error can occur for one of the following reasons: v The definition of new table is specified to be Â’likeÂ’ an existing view which references data from multiple encoding schemes. v The parent and child tables referenced in the definition of a referential constraint containing one or more non-numeric columns are encoded with different encoding schemes. v The definition of a materialized query table uses a different encoding scheme than the containing table space. v The SELECT statement references data encoded in multiple encoding schemes, and also contains an INSERT statement that references data encoded with a single encoding scheme. This situation is not