Joined: 19 Feb 2005 Posts: 141 Location: South Africa
As far as the criteria that you have mentioned ie. you didn't use a with hold in the cursor def and you din't issue a COMMIT.
The result is that thew changes you have requested will be rolled back to the previous syncpoint.
If you have issued a commit, then all the work will be saved when it comes across a COMMIT, and your cursor will be closed and a syncpoint will be established, but unless you have defined it with a WITHHOLD option your cursor wont be closed.