-873   THE STATEMENT REFERENCED DATA ENCODED WITH DIFFERENT ENCODING SCHEMES OR CCSIDS IN AN INVALID CONTEXT

The SQL statement references 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:

• The definition of a new table is specified to be 'like' an existing view which references data from multiple encoding schemes.
• 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.
• The definition of a materialized query table uses a different encoding scheme than the containing table space.
• The SELECT statement references data that is encoded in multiple encoding schemes, and also contains an INSERT, DELETE, UPDATE, or MERGE statement that references data that is encoded with a single encoding scheme.
• An INSTEAD OF trigger is created on a view that references multiple encodings or CCSIDs.