Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 10256
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 unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us