Transactions  Datatype entry rules

Chapter 7: Adding, Changing, and Deleting Data

Using the sample databases

If you follow the examples in this chapter, Sybase suggests that you start with a clean copy of the pubs2 or pubs3 database and return it to that state when you are finished. See a System Administrator for help in getting a clean copy of either of these databases.

You can prevent any changes you make from becoming permanent by enclosing all the statements you enter inside a transaction, and then aborting the transaction when you are finished with this chapter. For example, start the transaction by typing:

begin tran modify_pubs2

This transaction is named modify_pubs2. You can cancel the transaction at any time and return the database to the condition it was in before you began the transaction by typing:

rollback tran modify_pubs2




Copyright © 2005. Sybase Inc. All rights reserved. Datatype entry rules

View this book as PDF