Hi,

When Iam trying to join the table with the view, Iam getting this error.

Select * from U90EFRT.GEO_BOUNDARY
WHERE C_GEO_BNDRY_TYP_ID = 1
AND CHILD_GEO_BNDRY_ID in
(SELECT STATE_PRVNC_ID FROM U90EFRT.SUBSTATE_GRP_DM
)

Where GEO_BOUNDARY is a view and SUBSTATE_GRP_DM is a table.

Iam getting this error"
53090(-873)[IBM][CLI Driver][DB2] SQL0969N There is no message text corresponding to SQL error "-873" in the message file on this workstation. The error was returned from module "DSNXOEND" with original tokens "". SQLSTATE=53090

(2.09 secs)
Could you tell me why?

Thanks
Vikram

Here's the error from the V7 manual:

-873 DATA ENCODED WITH DIFFERENT ENCODING SCHEMES CANNOT BE REFERENCED
# IN THE SAME SQL STATEMENT

| Explanation: You cannot refer to a column defined in a table in one
| encoding scheme in the same SQL statement as a column defined in a table
| of another encoding scheme.

| This situation can occur when a table created in either the ASCII, EBCDIC,
| or UNICODE encoding schemes is referenced in a statement with a table that
| is not in the same encoding scheme.

This situation can also occur when a table is created; a DECP CCSID value
is changed; another table is created, and then the two tables are
referenced in a single SQL statement.

System Action: The statement cannot be executed.

Programmer Response: Correct the SQL statement.