Item description for SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8 by Galina Landres & Vlad Landres...
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 resource covers all SQR language elements and features, showing developers the best ways of utilizing the language's capabilities and demonstrating good programming habits. Written in a tutorial style, this new edition covers the basics and leads users toward a full understanding of the subject. All of the features of the SQR language are described, as are the aspects of interaction between SQR programs and Peoplesoft. This replaces 1884777775.
Outline 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.
Promise Angels is dedicated to bringing you great books at great prices. Whether you read for entertainment, to learn, or for literacy - you will find what you want at promiseangels.com!
Galina Landres has developed IS solutions for Waldenbooks, Entex, Coopers & Lybrand, Seagram, and Universal Studios. Vlad Landres has 25 years of experience with systems design, programming, and project management for the banking and insurance industries. They live in Stamford, Connecticut.
Reviews - What do customers think about SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8?
There is no shortage of solid advice Jan 12, 2004
Expert systems designer and programmer Vlad Landres and PeopleSoft specialist Galina Landres have completely revised and updated this second edition of SQR In PeopleSoft And Other Applications. Covering the fundamentals of the SQR version 6, and how to integrate SQR programs with PeopleSoft version 8, SQR In PeopleSoft And Other Applications is packed from cover to cover with reusable code examples, warnings of pitfalls, efficient methods, effective-dated tables, complete SQR syntax reference, and so much more. There is no shortage of solid advice and demonstrations in this straightforward and strongly recommended "hands-on" guide.
From a functional PeopleSoft user's standpoint Mar 8, 2003
I bought this book hoping it would supplement the PeopleSoft SQR class and in general was not disappointed, given my expectations. I knew it wouldn't include anything on PeopleSoft 8; thus the illustrations in the "SQR and PeopleSoft" section are dated. However, the examples in the section on working with effective-dated tables were very useful and apply to all releases. I haven't read the "Advanced Features" section of the book yet, because I was discouraged a bit when I had trouble grasping a few of the concepts in the SQR Basics section. I was pleased that their sample database, on which the reports are based, is modeled on the HRMS JOB, EMPLOYMENT, and PERSDATA tables; however, including sample output with each of their exercise/illustrations would have been helpful.
In summary, if you are a pretty experienced functional person (I am a consultant), are motivated enough to invest the time to learn SQR, and have access to the tool, this may be a good choice. Certainly more information (understandably) than you can get from a five-day SQR class.
*The* standard reference on SQR Aug 26, 2002
Aside from the fact that there is no other book that teaches SQR, this book is unique and valuable for following reasons:
- It teaches good programming practices. Anyone who has developed in any procedural language (including scripting and query languages) can quickly learn SQR. Therein lies a problem that this book overcomes: the excellent advice given about program development and structure can offset bad habits picked up in other languages.
- It's a definitive resource for SQR developers. Although SQR is relatively easy to learn, it's also rich with features missing from most other languages, such as complete control over printed and screen output, built-in constructs for graphs and charts, and multiple output file formats. Using many of these features not easy for beginners or programmers more used to other languages, but this book shows by example how to exploit every feature SQR has to offer.
- It dispels the common notion that SQR is a PeopleSoft-only tool. In fact, PeopleSoft doesn't own the language, and SQR will work in any database environment. More important, the book shows how to develop application and database independent programs that will work in any environment. This is an awakening for those who are going down proprietary paths, such as standardizing on Oracle's PL/SQL. While PL/SQL itself a powerful language, but is limited to Oracle - migrating from Oracle to, say, DB2 requires that all PL/SQL programs be scrapped. Had the applications and reports been developed in SQR the only changes would be to tables referenced.
In addition to the above, this book also provides good practices for forming SQL queries and understanding how a poorly formed join can make the difference between a resource hog and an unintrusive application. Since SQL, like SQR, is easy to learn many developers take the path of least resistance and develop queries with no thought on their effect on production systems. This book gives sound advice for avoiding that mistake.
The section on PeopleSoft, while out of date with respect to version 8, still contains valuable information for the majority of SQR developers whose exposure to SQR is via PeopleSoft.
There is something for everyone in this book - beginners can learn SQR the right way, and seasoned developers will have a ready reference that covers almost every facet of SQR in practical terms. If your job is primarily SQR development I also recommend that you also get a copy of "SQR Programmer Reference" by Don Mellen (ISBN 0967773008) as a quick reference to the features and nuances of SQR.
Holy Smokes Apr 26, 2002
You need this book if you are going to write SQR(s). However, you won't use it much with PS 8. You'll use App Engine.
Great !! Nov 2, 2001
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.