Hi...i am inserting rows into oracle table using upsert mode. The job is showing the number of rows it is processing from input to output , but when i see through toad in the table i am not seeing any rows inserted? My job is
actually there are no rows before in this table. I have truncated all of them and trying to insert new rows.
I tried to insert a row at the database level through sqlplus and it is working and i dont know whats the problem with datastage not able to insert
but when i see from toad it is still not showing the row that i inserted but at sqlplus i am able to see it and the rowcount as 1. In toad rowcount is 0
So having run through Datastage, you can see a row was inserted (when using sqlplus) but in Toad you can't see it then. Your issue lies with how Toad is viewing data then I imagine - maybe Toad is looking at a different schema or something? Certainly sounds like Datastage is doing its job from your last description. I haven't got Toad here I'm afraid and it's been a good few years since I did use it, so I can't help any more on the specifics of that I'm afraid.
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
i am using upsert option. does the insert starts immediately inserting the rows. bcoz...my job ran for 2hrs and aborted in the middle due to connection failure and non of the rows are inserted. What could be the reason for this?
Someone mentioned for you to create a reject link off the Oracle Stage so that you can see if there rejecting vs. actually loading.....I agree bet there rejecting....
Someone mentioned for you to create a reject link off the Oracle Stage so that you can see if there rejecting vs. actually loading.....I agree bet there rejecting....