|
SQR in PeopleSoft and Other Applications Second Edition PeopleSoft v. 8 Galina Landres and Vlad Landres 2003 | 696 pages ISBN: 1932394001 |
|||
![]() |
$69.95 | Softbound print book | |
![]() |
$35.00 | PDF ebook | |
Preface
Almost five years have passed since the first edition of this book arrived at bookstores and on the Internet. Since then, SQR has been upgraded to version 6 and many PeopleSoft developers are busy working with version 8.
The first edition had become dated and we faced the dilemma: to upgrade or not to upgrade. Almost 200 of our readers emailed and asked us to upgrade. Our publisher asked us to upgrade. Still we were hesitant. But when a friend bought the book and expressed puzzlement about a subchapter addressing the Year 2000 problem, we knew we were outvoted. The polls closed, the final count was 3 to 2: the readers, the publisher, and the friend vs. the two of us. Now, you have the result on your bookshelf (or maybe even on your desk).
So, what’s new in the second edition? A lot.
The SQR language chapters have been upgraded to version 6. More real-life examples were added; for instance, how to generate Word documents from SQR. HTML enabling coverage was expanded to cover SQR features added since the time of the first edition release.
The PeopleSoft part was almost entirely redone to cover PeopleSoft version 8. We discuss the new PeopleSoft Internet Architecture (PIA). We added a separate chapter concerning the Process Scheduler recurrences and Job streams. Special attention was given to PeopleSoft security and how to handle profiles, roles, and permission lists. Finally, all navigation and screens that developers go through are for version 8.
DESCRIPTION
Programmers, database developers, administrators responsible for PeopleSoft support, functional users, and project managers are discovering SQR, or Structured Query Report Writer, which has become increasingly popular since PeopleSoft selected it as its main SQL processing and reporting tool. This new language liberates programmers from the constraints of SQL and allows them to concentrate on the application aspects of their programs. This new edition covers all SQR language elements and features, showing developers the best ways of utilizing the languages capabilities and demonstrating good programming habits. Written in a "let’s do it together" tutorial style, this book starts with the basics and leads users toward a full understanding of the subject. Part one describes the SQR language with all of its features, while part two covers all aspects of interaction between SQR programs and PeopleSoft. This makes the book a working manual for both SQR programmers and PeopleSoft developers.
This book
- Reflects current version of PeopleSoft v.8
- Shows how to integrate SQR programs and PeopleSoft
- Provides 100+ examples of real life source code
Audience
- Programmers responsible for the development and support of SQR-based applications
- PeopleSoft developers who write and maintain SQR programs designed to function in the PeopleSoft environment
- PeopleSoft functional users, project leaders and managers
- Database administrators
ABOUT THE AUTHORS...
Galina Landres has developed IS solutions for Waldenbooks, Entex, Coopers & Lybrand, Seagram, and Universal Studios.
Vlad Landres has 25 years experience with systems design, programming, and project management for the banking and insurance industries. Both live in Stamford, Connecticut.

