Sample Databases

SAP ASE includes the pubs2 and pubs3 sample databases, which are used for most examples in the documentation.

SAP 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. 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