I am getting an SQLCODE = -4700, SQLSTATE = 56038 on
Below SQL returned - SQLCODE = -4700, SQLSTATE = 56038 We are on version 8 of DB2 but not in NFM yet
-
UPDATE CORETSTA.DDA C
-
SET C.B1_ACCT_PROD_CD = (SELECT B1_ACCT_PROD_CD
-
FROM CORETSTB.DDA B
-
WHERE B.FINL_ENTY_ID =
-
A.FINL_ENTY_ID
-
AND B.ACCT_NBR =
-
A.ACCT_NBR)
-
WHERE EXISTS (SELECT 1
-
FROM CORETSTB.DDA B
-
, CORETSTA.DDA A
-
WHERE A.FINL_ENTY_ID = '01'
-
AND B.FINL_ENTY_ID = A.FINL_ENTY_ID
-
AND B.ACCT_NBR = A.ACCT_NBR)
-
I modified the above and it worked..below is the modified one.
-
UPDATE COREINTA.DDA A
-
SET ACCT_ANAL_CD =
-
(SELECT ACCT_ANAL_CD
-
FROM COREINTB.DDA X
-
WHERE X.FINL_ENTY_ID = A.FINL_ENTY_ID
-
AND X.ACCT_NBR = A.ACCT_NBR)
-
WHERE A.FINL_ENTY_ID = '01';