query based on conditon???

[ahmedwaseem2000]

error

Copy_of_DB2_UDB_Enterprise_48: DB2 Error: The Orchestrate update field `column` is not an Orchestrate insert field.

query:

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' )

Incase, If i remove the word Orchestrate the job works fine but the row is not being updated.
could you please suggest me know what could be the solution for this???

[ray.wurlod]

...the job works fine but the row is not being updated...

On what basis does "the job work fine?"

[ahmedwaseem2000]

I meant the job runs fine without error but doesnt update it. and with orchestrate it gives me the error

[swades]

Did only Update works ?

AND

Only insert works ?

[DSguru2B]

As Ray advised before, send in a link with only inserts, and a reject link coming out of it going to another stage with updates.