query:Copy_of_DB2_UDB_Enterprise_48: DB2 Error: The Orchestrate update field `column` is not an Orchestrate insert field.
Code: Select all
Update query:
UPDATE
schema.tablename
SET
FLAG = 'N',
expr_date = ORCHESTRATE.EXPR_DATE
WHERE
(COL1=ORCHESTRATE.COL1 and FLAG = 'Y')
insert query:
INSERT
INTO
schema.tablename
(FLAG,expr_date)
VALUES
('Y', '9999-12-31-00:00:00:0' )
could you please suggest me know what could be the solution for this???