unable to see the data after inserting
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
unable to see the data after inserting
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
dataset---->oracle enterprise stage
Can any one let me know the reason for it?
dataset---->oracle enterprise stage
Can any one let me know the reason for it?
Add a reject link to your oracle stage and see if any links go down that path.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
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
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>Nothing appeases a troubled mind more than <b>good</b> music</i>
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm