Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Unanswered: DB2 Error SQL error "-873"

    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

  2. #2
    Join Date
    Aug 2004
    Posts
    330
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •