By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,948 Members | 1,595 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,948 IT Pros & Developers. It's quick & easy.

rollback load by cursor

P: 1
I want to use load by cursor for obvious performance reasons, but following execution of a SQL script I need to check the Unix return code and either commit or rollback, is there anyway I can use load by cursor?

I'm running the SQL from a shell script calling with commit hold
db2 -t +c -f sqlscript.sql
then reading the unix return code and issuing either commit or rollback, but in the event of a failure condition in load by cursor it issues rollback but the rows are there in the target table still, does anyone know how I can overcome this?
Jun 1 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.