Amazon.com
SQR in PeopleSoft and Other Applications fills a big gap in the enterprise computing marketplace. For starters, this book explains (beginning from near zero) how to program with Structured Query Report Writer (SQR). It discusses the peculiarities of writing SQR software to interact with PeopleSoft databases. Readers are shown how to integrate SQR programs with the Process Scheduler and how to take advantage of the PeopleSoft API. There's coverage of SQC files and the mechanics of calling SQR code from PeopleSoft online panels, plus appendices that document command-line flags and built-in functions.
The authors' approach to the topic reflects their considerable experience as SQR and PeopleSoft consultants. SQR in PeopleSoft--particularly its more advanced sections--contains lots of code that feels like it came only slightly modified from a consulting job. One particularly neat element is an SQR program that uses a flat file to provide an interface between PeopleSoft and IBM/Lotus cc:Mail. Though there's no companion CD-ROM, you can download all the code from the publisher's Web site. The code is well organized and serves as a fine base for the tutorial provided. --David Wall
Topics covered: SQR data elements fundamentals, pages, programs, and procedures; query and reporting capabilities; advanced SQR capabilities; graphics (including bar coding); Internet integration; and complex data structures.
CompBookReview.com, October 99
"Presented as a tutorial, SQR in PeopleSoft and Other Applications addresses the fundamental SQR language elements with an judicious eye towards making the most of SQR's capabilities. In addition to over one hundred realistic examples for both the novice and veteran, various approaches are offered and critiqued for each problem. Perhaps the *only* available source for real world PeopleSoft problems!
There aren't many SQR books out there so it's wonderful to see such a thorough and detailed title available. *Best of Class*"
See all Editorial Reviews