Sqr in PeopleSoft and Other Applications [Paperback]

Galina Landres (Author), Vlad Landres (Author)

Book Description

Publication Date: July 1999

This book starts with the basics and leads the reader through a hands-on tutorial on Structured Query Report Writer.

Editorial Reviews

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

See all Editorial Reviews

Product Details

• Paperback: 600 pages
• Publisher: Manning Publications (July 1999)
• Language: English
• ISBN-10: 1884777775
• ISBN-13: 978-1884777776
• Product Dimensions: 8.9 x 7.5 x 1.5 inches
• Shipping Weight: 2.2 pounds
• Average Customer Review: 4.8 out of 5 stars  See all reviews (29 customer reviews)
• Amazon Best Sellers Rank: #1,372,328 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

15 of 15 people found the following review helpful:

5.0 out of 5 stars GREAT BOOK, April 28, 1999

By 

[e-mail] (Brooklyn, NY) - See all my reviews

This review is from: Sqr in PeopleSoft and Other Applications (Paperback)

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.

12 of 12 people found the following review helpful:

5.0 out of 5 stars A 'Must-Have' for PS Developers, January 16, 2000

By 

JOHNSIMON K LAM [e-mail] (Omaha, NE) - See all my reviews

This review is from: Sqr in PeopleSoft and Other Applications (Paperback)

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.

10 of 10 people found the following review helpful:

5.0 out of 5 stars Great !!, November 1, 2001

By 

Frederick L. Merritt Jr. (Louisville, KY USA) - See all my reviews
(REAL NAME)   

This review is from: Sqr in PeopleSoft and Other Applications (Paperback)

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.