Hi
I am working with Oracle enterprise state and would like to do a custom insert sql.
Under the current options we can only do a insert in the upsert mode but we need to do include custom update statement also. I was wondering if I had to do a custom sql insert statements only, how will I do it.
Please inform
Thanks.
Oracle enterprise Insert only
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 166
- Joined: Wed Mar 16, 2005 6:52 am
- Location: Mumbai, India
If I remember right (No access to PX now ), select the "User-defined Update Only." mode and write an insert statement instead.
It works.
It works.
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
That's right. You set it up for a generated upsert and that gives you a generate insert and update statement. You copy your insert statement into the clipboard. You switch it to user-defined update and then paste the insert statement into the entry screen and modify it to suit.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
This works if there are no rejects. But the job aborts if there are rejects while inserting.vmcburney wrote:That's right. You set it up for a generated upsert and that gives you a generate insert and update statement. You copy your insert statement into the clipboard. You switch it to user-defined update and then paste the insert statement into the entry screen and modify it to suit.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: