CHAPTER 10Structured Query Reporting

This chapter introduces the Structured Query Reporting (SQR) programming language used for extracting data from the database, reporting, and writing files. We will look at how SQR uses Structured Query Language (SQL) to communicate with relational databases. The SQR tool has its own language and structure; when used with SQL, it can produce reports and files. You will learn SQR procedures, commands, and functions that will enable you to produce informative files and reports. PeopleSoft recommends that SQR be used only for reporting because application edits are not applied when data is changed using the SQL commands.

Prior to PeopleTools release 8.46, SQR was the main reporting tool delivered with the PeopleSoft ...

Get PeopleSoft Developer's Guide for PeopleTools & PeopleCode now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.