SQL Error: State:21000, Native Code: FFFFFCD5

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Bre035
    New Member
    • Sep 2007
    • 42

    SQL Error: State:21000, Native Code: FFFFFCD5

    I have received the error State:21000, Native Code: FFFFFCD5 when attempting to run the following SQL Query to update column using the data from another DB2 Table column.

    Code:
    UPDATE db2prod.arts_case_research
    SET
    agent_ID =(SELECT db2prod.arts_case_research_AUDIT.agent_ID FROM db2prod.arts_case_research_AUDIT WHERE db2prod.arts_case_research.case_number
    =db2prod.arts_case_research_AUDIT.case_number AND db2prod.arts_case_research_audit.audit_action = 'I' AND BUSINESS_UNIT_CODE = 'FM' )
    WHERE db2prod.arts_case_research.case_number = (SELECT db2prod.arts_case_research_audit.case_number
                                 FROM   db2prod.arts_case_research_audit
                                 WHERE db2prod.arts_case_research.case_number
                                 =db2prod.arts_case_research_AUDIT.case_number
                                AND  db2prod.arts_case_research_audit.audit_action = 'I'
                                AND BUSINESS_UNIT_CODE = 'FM');
    Last edited by Rabbit; Oct 31 '13, 03:41 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.
Working...