|
View previous topic :: View next topic
|
| Author |
Message |
rarvins
New User
Joined: 24 Jan 2007
Posts: 59
Location: Texas
|
|
|
|
Hi,
I have a global temporary table which gets cleaned whenever i issue a commit in the Cobol-DB2 pgm.So i declared the temp table with preserve option.Now if i issue a roll back, will the cotent of the temp table get reversed or will it remain the same
Cheers,
Rarvins |
|
| Back to top |
|
 |
vini_srcna
Active User
Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark
|
|
|
|
| I dont think ROLLBACK will preserve the data. Not sure though |
|
| Back to top |
|
|
ashok_uddaraju
New User
Joined: 21 Feb 2007
Posts: 72
Location: US
|
|
|
|
hi,
the temp table only records the roll back u issued but does not show effect on the results |
|
| Back to top |
|
|
|
|
