View previous topic :: View next topic
|
Author |
Message |
ravi_asgm Warnings : 2 New User
Joined: 07 Jun 2007 Posts: 5 Location: ap
|
|
|
|
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 |
|
|
aqilis
New User
Joined: 23 Feb 2007 Posts: 17 Location: NOIDA
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
prasadvrk
Active User
Joined: 31 May 2006 Posts: 200 Location: Netherlands
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
I think not.
Keep that up and you won't be here long. . . |
|
Back to top |
|
|
ravi_asgm Warnings : 2 New User
Joined: 07 Jun 2007 Posts: 5 Location: ap
|
|
|
|
thank u sir |
|
Back to top |
|
|
|