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?
field is not an Orchestrate insert field.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: