SQR for PeopleSoft Implementation

This section describes the prerequisites for implementing SQR for PeopleSoft.

  • You need a sound understanding of SQL and structured programming languages to use the SQR language.

  • You do not need to carry out a separate installation procedure because SQR for PeopleSoft is installed automatically when you install PeopleTools.

  • Typically, you should use Application Engine to run background SQL processing programs. You may want to explore whether Application Engine can meet your needs before delving into SQR.

    See Application Engine.

  • You can run SQR programs locally by using the SQR executable (for Microsoft Windows it is SQRW) and through the PeopleSoft Process Scheduler. For details on installing Process Scheduler and running SQRs using Process Scheduler,

    See PeopleSoft Process Scheduler and Understanding the Management of PeopleSoft Process Scheduler.

See the product documentation for PeopleSoft 9.2 Application Installation.

Note: From PeopleTools 8.54 release, the SQR executables, such as, SQRW,SQWT,SQRWP, and SQRWT are x64 bit binary on Windows platforms.