Installing Sample Databases

The sample databases, which contain fictitious information, are designed to help you learn how to use SAP ASE. The sample databases are intended for training purposes only. Do not install them in an SAP ASE production environment.

File NameDescription
Installs the pubs2 sample database. This database contains data that represents a publishing operation. Use this database to test your server connections and to learn Transact-SQL. Most of the examples in the SAP ASE documentation query the pubs2 database.
Note: The master device size should be at least 30MB to install the full pubs2 database, including the image data.
Installs the pubs3 sample database. This updated version of pubs2 uses referential integrity. In addition, its tables are slightly different than the tables used in pubs2. Where noted, the SAP ASE documentation uses the pubs3 database in its examples.
Installs the image data that is used with the pubs2 database.

Run the instpix2 script after you run instpbs2.

The image data requires 10MB—there are six pictures, two each in the PICT, TIFF, and Sun raster file formats. Run installpix2 script only to use or test the image datatype. SAP does not supply any tools for displaying image data; you must use appropriate window graphics tools to display the images after you have extracted them from the database.
Related concepts
Postinstallation Tasks
Related tasks
Minimally Configuring an SAP ASE Server