Hi,

I have a parent table and child table in datawarehouse environment(SCD2)
I have unix script(join Query comparing existing with new) to load the Parent table first and child table next.

If the unix script fails in middle how can i rollback.which is the best approach to do that.

Parent table(which have surrogate function)
Child table referencing to the Parent Table.

Please Suggest me

On top of my head ([please test first)
- set autocommit off!
- code a commit after succesfull completion

This should do the job. If you can trap an error then code a rollback there, otherwise DB2 will rollback automatically when the connection fails.

But again: do not take my word for it an test it first (should not be too hard).

Dr_te is right on the money. Make sure your script checks on the return code prior to issuing a commit statement.

Huh? What? Do I get paid for this?

Sure, I will double your pay if you continue this way

DUOBLE my pay! Jipeeeee.
2 times $0 (in my case :2 times EUR 0). Now I can feed my children and have a myself.