Oracle enterprise Insert only

babbu9 · Post by **babbu9** » Wed Dec 07, 2005 6:15 pm

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.

ameyvaidya · Post by **ameyvaidya** » Wed Dec 07, 2005 6:37 pm

If I remember right (No access to PX now

), select the "User-defined Update Only." mode and write an insert statement instead.

It works.

vmcburney · Post by **vmcburney** » Wed Dec 07, 2005 11:26 pm

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.

sri1dhar · Post by **sri1dhar** » Wed Aug 23, 2006 10:30 am

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.

This works if there are no rejects. But the job aborts if there are rejects while inserting.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 24, 2006 12:12 am

Do you have a rejects-handling output link from the Oracle Enterprise stage?

sri1dhar · Post by **sri1dhar** » Thu Aug 24, 2006 10:00 am

ray.wurlod wrote:Do you have a rejects-handling output link from the Oracle Enterprise stage?

Yes, to a peek stage

ray.wurlod · Post by **ray.wurlod** » Fri Aug 25, 2006 1:17 am

What do you see in the Peek entries in the job log?