Rollback when job finishes with warnings

[dsscholar]

I am inserting data in DB2 table and I have set transactional handling as 0 to rollback in case the load doesnt finish sucessfully. My question is whether rollback will take place only if the job fails/aborts or even if the job finishes with warnings ?

Thanks

[chulett]

The job has to Abort to initiate the rollback.

[dsscholar]

Thanks Craig..

[tagnihotri]

Although just to point out, you may have cases of dataloss even if the job finishes with warning

Thanks Craig..

[loveojha2]

Do get rid of such a dataloss case, make sure your job aborts even when it generates a warning, if that's what you want.

[tagnihotri]

Aborting job even when you get any warning hmmmmm

You need to be preety sure if you need this, as in many cases I have seen dataloss with warnings but its not always. So you may end up aborting your job in half way even when you get "informative" warnings.

Do get rid of such a dataloss case, make sure your job aborts even when it generates a warning, if that's what you want.

[loveojha2]

Do get rid of such a dataloss case, make sure your job aborts even when it generates a warning, if that's what you want.

Just a typo

To get rid of such a dataloss case, make sure your job aborts even when it generates a warning, if that's what you want.