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.