Page 1 of 1

field is not an Orchestrate insert field.

Posted: Wed Aug 25, 2010 7:22 pm
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?

Posted: Wed Aug 25, 2010 8:53 pm
by ray.wurlod
The names in the ORCHESTRATE structure must match those in the Columns grid of the stage.