Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
I have updated row in table using SPUFI . How to revert

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: I have updated row in table using SPUFI . How to revert
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    Post subject: Re: I have updated row in table using SPUFI . How to revert
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10308
Location: italy

PostPosted: Wed Jun 20, 2007 3:46 pm    Post subject: Re: I have updated row in table using SPUFI . How to revert
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    Post subject:
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

Site Director


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

PostPosted: Wed Jun 20, 2007 8:32 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am
No new posts Adding a userid to SMTP Security table Yolanda Harvey JCL & VSAM 1 Sun Aug 13, 2017 6:16 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us