Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

wintersun1981
2012-04-26 07:50:09

ok, I tried your suggestion and it works well.
Thanks.

pedro
2012-04-23 07:51:02

Hi

According to what you said in the post,

Code:

update may have no results because no keys are matched in the table

Why don't you use tMap to inner join these two tables and update them by using tOracleOutput?

Regards,
Pedro

wintersun1981
2012-04-20 12:21:25

Hi, Pedro:

Do u have an example of tOracleSCD component? I'm confused with its description.
My problem is update may have no results because no keys are matched in the table. In this case I want to report an error to end-user.
Thanks!

pedro
2012-04-20 11:42:59

Hi

You have been able to use tOracleSCD to get reject rows.
But recently a bug of tOracleSCD occurs in TOS 5.0 and 5.1.
You may have a try.

Regards,
Pedro

wintersun1981
2012-04-20 11:23:48

Hi, all:

I'm using tOracleOutput component to insert/update data for a table. Do we have a component to retrieve the execution results? I want to know the successful records for insert/update and detailed information in case of failure.

Thanks!

Board footer

Powered by FluxBB