IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

I have updated row in table using SPUFI . How to revert


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ravi_asgm
Warnings : 2

New User


Joined: 07 Jun 2007
Posts: 5
Location: ap

PostPosted: Wed Jun 20, 2007 12:27 pm
Reply with quote

Hi Sir
pls reply me


1. How to load data into table.?
2. I have updated row in table using SPUFI . How to revert the updated row? it means original position
[/b]
Back to top
View user's profile Send private message
aqilis

New User


Joined: 23 Feb 2007
Posts: 17
Location: NOIDA

PostPosted: Wed Jun 20, 2007 3:38 pm
Reply with quote

My god!!!

For loading a table : use DSNUPROC
: give the dataset name 9that contains data to be loaded
in SYSREC00
: give the load card in SYSIN.

Have u heard of ROLLBACk/COMMIT.
you can use them in SPUFI as well as your program.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Jun 20, 2007 3:46 pm
Reply with quote

Quote:
I have updated row in table using SPUFI . How to revert the updated row?


It depends ....

If You already issued a "COMMIT" for the update, then Your luck is not at top level

- if You remember the previous values, reset them by hand rerunning "SPFUFI" with the appropriate queries
- restore the table from an image copy

If You are in the middle of Your doings a "ROLLBACK" might help

regards
e.s
Back to top
View user's profile Send private message
prasadvrk

Active User


Joined: 31 May 2006
Posts: 200
Location: Netherlands

PostPosted: Wed Jun 20, 2007 7:10 pm
Reply with quote

Before runing the SPUFI, you can set the defaults where it will prompt whether to COMMIT the transaction or not (i.e. AUTOCOMMIT=?'or 'N' , If you specify '?' there is no option but to follow what enrico has advised otherwise it will ask you to commit at the end, when you may opt not to commit
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Jun 20, 2007 8:32 pm
Reply with quote

Hello,

I think not.

Quote:
My god!!!


Keep that up and you won't be here long. . .
Back to top
View user's profile Send private message
ravi_asgm
Warnings : 2

New User


Joined: 07 Jun 2007
Posts: 5
Location: ap

PostPosted: Thu Jun 21, 2007 11:20 am
Reply with quote

thank u sir
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts DELETE SPUFI DB2 1
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Adding QMF and SPUFI to the ISPF menu DB2 20
No new posts Multiple table unload using INZUTILB DB2 2
Search our Forums:

Back to Top