field is not an Orchestrate insert field.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
yimwai
Participant
Posts: 46
Joined: Thu Jul 01, 2010 9:34 pm

field is not an Orchestrate insert field.

Post by yimwai »

when I do update and insert in one DB2 enterprise stage ,the error message is field `I_DTE' is not an Orchestrate insert field.
my update and insert statement is as follow:

UPDATE CC_CDW.F_CLT_ADR SET
END_DTE = DATE('#I_DATE#')-1 DAY
WHERE (CLT_ID = ORCHESTRATE.CLT_ID
AND CTT_TYP_COD = ORCHESTRATE.CTT_TYP_COD
AND STR_DTE = ORCHESTRATE.STR_DTE
AND ORCHESTRATE.HasChanged=3)

INSERT INTO CC_CDW.F_CLT_ADR
(CLT_ID, CTT_TYP_COD, ZIP_COD, STR_DTE, END_DTE)
VALUES (ORCHESTRATE.CLT_ID,
ORCHESTRATE.CTT_TYP_COD,
ORCHESTRATE.ZIP_COD,
ORCHESTRATE.I_DTE,
ORCHESTRATE.END_DTE)
WHERE ORCHESTRATE.HasChanged=1 or ORCHESTRATE.HasChanged=3

Do I need to keep the name of input field the same with that in the database?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The names in the ORCHESTRATE structure must match those in the Columns grid of the stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply