Product Description

Programmers, database developers, functional users and project managers are discovering SQR as the main processing and reporting tool in SQL. This book covers all SQR language elements and features, showing the readers the best ways of utilizing the languages capabilities and demonstrating good programming habits. Written in a "let's so it together" tutorial style, this book starts with the basics and leads the reader 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 programs and PeopleSoft developers.

Product Details

• Amazon Sales Rank: #582128 in Books
• Published on: 1999-07
• Original language: English
• Number of items: 1
• Binding: Paperback
• 600 pages

Amazon.com Review
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.

Review
"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*" -- CompBookReview.com, October 99

About the Author

Customer Reviews

GREAT BOOK
The scope of coverage is complete. It is understandable to someone with little experience while briskly moving from one topic to the next, with good examples. The material is organized well - simple to complex SQR, then putting SQR's online into Peoplesoft, then the nitty gritty of working with history and interfaces with Peoplesoft. Glossaries are at the end. It's not too long, not too short. The author is stimulating, not belabored with theory, yet topics are thorough and more than one example is used. Look for a great style - doing something slightly wrong, and then the author pointing it out and repeating the answer with the correct solution. Printing summaries at the end of each chapter is good. Illustrating points with call-out boxes overimposed onto actual programming code is also a great technique. The more advanced techniques the reader is able to master, the more valuable this book becomes. Specifically, arrays in chapter 11, loops in chapter 10, substitution topics in chapter 9, using breaks in reporting in chapter 8, are all intricate tools useful to the serious SQL programmer. Check out the entire table of contents at http://www.manning.com/Landres/Contents.html This book is for SQR programmers, project leaders, DBA's, installation consultants, consulting programmers. There are many books on SQL and SQR, including complete Oracle References. And there is book that is handed out at the Peoplesoft class on SQR. Landres' book is different in that it gives SQR from A to Z, it gives the Peoplesoft related topics, it gives actual upgrade and history topics (which I've seen nowhere). And unlike the Oracle books which are geared for DBA's, the approach is directed towards the specific goal of writing Peoplesoft SQR's. SQR for Peoplesoft is great and I highly recommend it.

A 'Must-Have' for PS Developers
I have few than six months of Peoplesoft and SQR experience but was able to code a module that completely replaces the delivered Overtime Calculation for Time and Labor from PS. This book has been a tremendous help and resource. One of the best investments I have ever made.

Examples are well illustrated. Explanation is very clear and relevant. A great book for developer with couple years of SQL experience.

Great !!
I was working on a problem a couple of years ago and took the suggestion of a co-worker to buy this book. For the last two years I have been using it as a reference. I spent a few months off and came back and embaressed myself puting a report in process scheduler. So I sat down and read the book front to back. I wish I had done this a couple of years ago.

I have been working with SQR for five years. I have used examples and the SQR manuals to accomplish what I wanted. This work provided me with a lot of knowledge that I had never taken the time to pick up. Now even if I take the time off and need a refresher the sections are highlighted.

I have found this book very useful as both a reference and a knoweldge builder. Also, the writing style was good enough that rereading the portions that I was alread aware of was not too irksome. Interestingly, I could swear some of the interview questions I have been asked came right out of this book.