Setting Up the Sample Database

To run the sample programs in this guide, you must create a sample database. To do so, run the loadall.sqr program:

  1. Change to the SAMPLE (or SAMPLEW for Microsoft Windows) directory under <PS_HOME>\bin\sqr\<database_platform>.

  2. At the command line, enter:

    sqr loadall username/password

If SQR is installed on Microsoft Windows, you can run loadall.sqr by double-clicking the Loadall icon. If your system does not display this icon, run loadall.sqr from the SAMPLEW directory of SQR for PeopleSoft.

If an individual table already exists, you are prompted to enter:

  • A: Abort the load.

  • S: Skip the specified table.

  • R: Reload the specified table.

  • C: Reload all tables.

You can also run this as a batch program by entering the preferred option (A, S, R, or C) at the command-line. For example: 

sqr loadall username/password a