DSXchange

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.

If I remember right (No access to PX now ), select the "User-defined Update Only." mode and write an insert statement instead.

It works.

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.

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.

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

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

Yes, to a peek stage

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