|
View previous topic :: View next topic
|
| Author |
Message |
saikat
New User
Joined: 23 Jun 2008
Posts: 26
Location: pune
|
|
|
|
Hi,
I know if I run multiple sql insert queries using DB2TEP2 utility and in case any query fails in between all records upto that point get committed and rest all get failed.
I would like to know if there is similar utility which issues auto roll back in above case so that in case of failure no records get committed. |
|
| Back to top |
|
 |
Pandora-Box
Global Moderator
.jpg)
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
| Quote: |
| I know if I run multiple sql insert queries using DB2TEP2 utility |
Are you sure if you are reffering to correct program name??
Hope it was typo for DSNTEP2 |
|
| Back to top |
|
|
saikat
New User
Joined: 23 Jun 2008
Posts: 26
Location: pune
|
|
|
|
| Its DB2TEP2, IBM's utility |
|
| Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
| Could you please share the code which you have tried keen to know about DB2TEP2 ( Not sure if thats an alias) or may be link to the DB2TEP2? |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
|
|
|
|
| Well, looking at the DB2 Utility manual's index there is no DB2TEP2 but there is DSNTEP2. Also, there is no reference to IBM manuals in the Google search. There appears to be a DB2TEP2 on the CBTTape but then it would not be IBM. |
|
| Back to top |
|
|
saikat
New User
Joined: 23 Jun 2008
Posts: 26
Location: pune
|
|
|
|
| Does DSNTEP2/DSNTEP4 issue rollback in case of sql failure? |
|
| Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
| What happen when you tried ? |
|
| Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
|
|
|
|
| DSNTEP2 and DSNTEP4 are written in PL/I, so if someone in your shop has the necessary skills, heesh could easily add a control parameter specifying commit frequency. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| I would like to know if there is similar utility which issues auto roll back in above case so that in case of failure no records get committed. |
No. Once committed, the data is committed and no longer a candidate for a ROLLBACK. |
|
| Back to top |
|
|
|
|
