I am using a Upsert with Insert first and update next, I have checked the column names which matches both in Insert and update queries. Can someone please suggest any workaround on this
Error:
<Table Name>: The Orchestrate update field `<Attribute>' is not an Orchestrate insert field;
in order to use the default host array processing for insert, the Orchestrate
fields for update must also be Orchestrate insert fields; this is not a requirement for insert
non-host array processing;
in order to select insert non-host array processing, set the -insertArraySize option to 1.
Oracle Enterprise stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Workaround is to set Array Size property to 1.
Even better would be to force generated SQL to be re-generated, for example by switching from generated = Yes to generated = No and back again.
Even better would be to force generated SQL to be re-generated, for example by switching from generated = Yes to generated = No and back again.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.