ij Commands and Errors Reference Page 30 of 39
[top]
[prev]
[next]
Table of Contents
Index
Documentation Top
Global Index
Absolute After Last Async Autocommit Before First Close Commit Connect Disconnect Driver Elapsedtime Execute Exit First Get Cursor Get Scroll Insensitive Cursor Help Last LocalizedDisplay MaximumDisplayWidth Next Prepare Previous Protocol Readonly Relative Remove Rollback Run Set Connection Show Connections UnicodeEscape Wait For
ROLLBACK
Issues a java.sql.Connection.rollback request. Use only if auto-commit is off. A java.sql.Connection.rollback request undoes the currently active transaction and initiates a new transaction.
ij> INSERT INTO menu VALUES ('dessert', 'rhubarb pie', 4); 1 row inserted/updated/deleted ij> SELECT * from menu; COURSE |ITEM |PRICE ----------------------------------------------- entree |lamb chop |14 dessert |creme brulee |7 appetizer |baby greens |7 dessert |rhubarb pie |4 4 rows selected ij> rollback; ij> SELECT * FROM menu; COURSE |ITEM |PRICE ----------------------------------------------- entree |lamb chop |14 dessert |creme brulee |7 appetizer |baby greens |7 3 rows selected
Cloudscape Version 3.6