06-15-2005
I dont think you can do this in any straight forward manner since each process is hitting the database in its own session. When the rollback is issued, it will only impact that session. If you need to do this, I would create a TEMP table that is a mirror of the working table. Process the records for each script in that TEMP table, then when the work is done, update the working table.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all
I am facing some problem taking INCREMENTAL Back up of file systems...........Actually i have mounted the file system of one server in another server..as i don't have tape drive in both servers...............i am using HPUX(L class and C class)servers..
can any one help me ... (1 Reply)
Discussion started by: Prafulla
1 Replies
2. UNIX for Dummies Questions & Answers
Hi..
I am using HP UX 11.0
i want to make automated back up from SAM back up tool....
so i mentioned the file systems and back up device /dev/rmt/0m and time 0:00 and days of the week........
but it was not successful.....the back up job was not started on specified time.....
i am in... (7 Replies)
Discussion started by: Prafulla
7 Replies
3. UNIX for Advanced & Expert Users
Hi ALL:
I am not able to get the response back from weblogic in the shell script.
The weblogic server in different account. I am able to login to that account and bring the server up but while doing a ping, the script is failing. While the same script is running fine if I run it on the account... (1 Reply)
Discussion started by: splax
1 Replies
4. UNIX for Advanced & Expert Users
I have a p570 server with 2 LPARs on it. One of my colleagues did a firmware upgrade on it over the weekend but I have not been able to bring it back online since.
I go to activate the partition from the HMC and it gets stuck on the C20082FF operator panel and just freezes from there.
Does... (2 Replies)
Discussion started by: KeesH
2 Replies
5. Shell Programming and Scripting
Hi,
I am trying to figure out if there is a way to make linux take me back to the previous directory I was working in. For instance, I am in
/home/username/directory1
Then if I cd into /home/username/directory1/temp1/temp2/temp3
I would like to immediately go back to the previous... (2 Replies)
Discussion started by: Legend986
2 Replies
6. Solaris
What is the easiest or preferred way to roll back the solaris cluster patches?
My guess is to do a flash archive pre-patch and then install off of that if it doesn't work.
Any other ideas? (4 Replies)
Discussion started by: adelsin
4 Replies
7. Solaris
Is there an easy way to roll back or uninstall the latest Solaris patch cluster? I'm hoping I don't have to go into each patch that was applied and uninstall them one-by-one.
Thanks! (0 Replies)
Discussion started by: bluescreen
0 Replies
8. Red Hat
Hi,
I want to roll back the packages that are installed during the patch installation of RHEL 5 server. There are in all 110 packages including the kernel package...
kernel-2.6.18-274.el5.x86_64.rpm
kernel-headers-2.6.18-274.el5.x86_64.rpm
How should I proceed ?
I don't want to run rpm... (4 Replies)
Discussion started by: aksijain
4 Replies
9. Shell Programming and Scripting
Hi
is there any shell script to roll back the code when the code is deployed in a wrong way in production servers (3 Replies)
Discussion started by: Purushotham
3 Replies
10. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Print out problem with line follow:
echo There are '$cat $fname | wc -l' contacts in database
how do I replace... (2 Replies)
Discussion started by: scopiop
2 Replies
ABORT(7) SQL Commands ABORT(7)
NAME
ABORT - abort the current transaction
SYNOPSIS
ABORT [ WORK | TRANSACTION ]
DESCRIPTION
ABORT rolls back the current transaction and causes all the updates made by the transaction to be discarded. This command is identical in
behavior to the standard SQL command ROLLBACK [rollback(7)], and is present only for historical reasons.
PARAMETERS
WORK
TRANSACTION
Optional key words. They have no effect.
NOTES
Use COMMIT [commit(7)] to successfully terminate a transaction.
Issuing ABORT when not inside a transaction does no harm, but it will provoke a warning message.
EXAMPLES
To abort all changes:
ABORT;
COMPATIBILITY
This command is a PostgreSQL extension present for historical reasons. ROLLBACK is the equivalent standard SQL command.
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)]
SQL - Language Statements 2010-05-14 ABORT(7)