ROLLBACK(7) SQL Commands ROLLBACK(7)NAME
ROLLBACK - abort the current transaction
SYNOPSIS
ROLLBACK [ WORK | TRANSACTION ]
DESCRIPTION
ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded.
PARAMETERS
WORK
TRANSACTION
Optional key words. They have no effect.
NOTES
Use COMMIT [commit(7)] to successfully terminate a transaction.
Issuing ROLLBACK when not inside a transaction does no harm, but it will provoke a warning message.
EXAMPLES
To abort all changes:
ROLLBACK;
COMPATIBILITY
The SQL standard only specifies the two forms ROLLBACK and ROLLBACK WORK. Otherwise, this command is fully conforming.
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)]
SQL - Language Statements 2010-05-14 ROLLBACK(7)
Check Out this Related Man Page
END(7) SQL Commands END(7)NAME
END - commit the current transaction
SYNOPSIS
END [ WORK | TRANSACTION ]
DESCRIPTION
END commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a
crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT [commit(7)].
PARAMETERS
WORK
TRANSACTION
Optional key words. They have no effect.
NOTES
Use ROLLBACK [rollback(7)] to abort a transaction.
Issuing END when not inside a transaction does no harm, but it will provoke a warning message.
EXAMPLES
To commit the current transaction and make all changes permanent:
END;
COMPATIBILITY
END is a PostgreSQL extension that provides functionality equivalent to COMMIT [commit(7)], which is specified in the SQL standard.
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)]
SQL - Language Statements 2010-05-14 END(7)
I have the following output. I want to write a script to check for
1. waits > 0 on all rowsand Ratio > .0. if true then send email.
=========================
ROLLBACK SEGMENT CONTENTION
=========================
If any ratio is > .01 then more rollback segments are needed
NAME ... (1 Reply)
I have a file which is of the format :-
/Ixxxxxx/WORK/HANDOFF;/xxxxxx/WORK/MB_BACKUP;<servername>;<dest-servername>;\\\\CAICMESF002DATA_GRP\OPERATIONS\IBBSSPOOLS\HANDOFF\;ACHOFF*;achoff;binary;3;1;|ACHOFF.zip;0;1;0;
I want to grep all capital and small OFF pattern in a format :-
... (2 Replies)
I am getting the following message in /var/adm/messages
Its harm to the system ?? in solaries 5.5.1
unix: WARNING: correctable error from pci0 (upa mid 0) during dvma read transaction.
unix:
unix: AFSR=40a200ff.80800000 AFAR=00000000.0132bee0,
unix: double word offset=4, SIMM DIMM1 id 31.... (1 Reply)
Hi
I am new to this forum.I need a help in the following:
We receve pipe delimited file with
transaction ID,tran_date,Quest_cd,Ans_cd,ans_value.
Same transaction ID can be repeated with different quest_cd and ans_cd.
Basically I need to check if a perticular pair of quest_cd and ans_cd (say... (13 Replies)
Hi guys, I'm hoping you can help me here. I've knocked up a script that looks at a (huge) log file, and pulls from each line the hour of each transaction and how long each transaction took.
The data is stored sequentially as:
07:01 blah blah blah 12456 blah
07:03 blah blah blah 234 blah... (4 Replies)
Hi,
I would like to access SQL plus from my unix, and learn to run some SQL scripts in Unix.
How do i begin. Is there any known website that offers a quick tutorial or tips?
Thanks,
unxhopeful (1 Reply)
Hi,
I would like to access SQL plus from my unix, and learn to run some SQL scripts in Unix.
How do i begin. Is there any known website that offers a quick tutorial or tips?
Thanks,
unxhopeful (4 Replies)
HI Guys
whenever i post a transaction , abcd.in file is stored in the temp and vanishes when the transaction is compleated . the abcd.in file stays for 1 sec in temp is der any solution to capture the abcd.in file to another directory
cp -r /tmp/abcd.in /tmp/smith.in
when i used the... (1 Reply)
Hi guys, I was wondering if someone can give me a hand in helping me append transaction header line in a file at the end of the transaction detail lines.
Basically, I have a file that looks like this:
FHEAD File1
THEAD TRANS1-blah
TDETL HI1
TDETL HI2
TDETL HI3
TTAIL TRANS1-blah
THEAD... (3 Replies)
Can some one help me related to .sql file issue.
I have a .sqlfile and tried to read the file thru unix. In the .sqlfile I have error rows as well and when error comes I dont want to proceed further and need to roll back all the transactions.
sample .sql file below
insert into
test... (2 Replies)
Hi,
I have an issue where i need to lookup in a given transaction file and if the same transaction is found in another file, then i need to replace a few columns with some other value.
Finally, the changed and unchanged lines must be printed and stored in the same source file.
for example... (5 Replies)
Hi All,
I have transaction in one file.I want to match that to another file and find the number of time the transaction is available on the other file.I need to take each record from TRANSFILE and match that with SPEND FILE and find the number of counts of the transaction
TRANSFILE:
... (4 Replies)