Newsletter   Secure Checkout   Shopping Cart (0 Items)  
Search:    Welcome Guest! Save up to 30-40% on most items with our awesome everyday discounts!

SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8 [Paperback]

Our Price $ 48.97  
Retail Value $ 69.95  
You Save $ 20.99  (30%)  
Item Number 255223  
Buy New $48.97
Out Of Stock!
Currently Out Of Stock
Currently unavailable...

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!

Item Specifications...

Pages   660
Est. Packaging Dimensions:   Length: 1.5" Width: 7.25" Height: 9.25"
Weight:   2.55 lbs.
Binding  Softcover
Publisher   Manning Publications
ISBN  1932394001  
ISBN13  9781932394009  

Availability  0 units.

More About Galina Landres & Vlad Landres

Register your artisan biography and upload your photo! 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.

Galina Landres was born in 1953.

Are You The Artisan or Author behind this product?
Improve our customers experience by registering for an Artisan Biography Center Homepage.

Product Categories

1Books > Special Features > New & Used Textbooks > Computer Science & Information Systems > Database Storage & Design
2Books > Special Features > New & Used Textbooks > Computer Science & Information Systems > Programming Languages
3Books > Subjects > Computers & Internet > Databases > General
4Books > Subjects > Computers & Internet > Databases > Specific Databases > SQL > General
5Books > Subjects > Computers & Internet > General
6Books > Subjects > Computers & Internet > Programming > General

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.


Write your own review about SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8

Ask A Question or Provide Feedback regarding SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8

Item Feedback and Product Questions
For immediate assistance call 888.395.0572 during the hours of 10am thru 8pm EST Monday thru Friday and a customer care representative will be happy to help you!

Help us continuously improve our service by reporting your feedback or questions below:

I have a question regarding this product
The information above is incorrect or conflicting
The page has misspellings or incorrect grammar
The page did not load correctly in my browser or created an error.

Email Address:
Anti Spam Question. To combat spammers we require that you answer a simple question.
What color is the sky?
Leave This Blank :
Do Not Change This Text :

Add This Product Widget To Your Website

Looking to add this information to your own website? Then use our Product Widget to allow you to display product information in a frame that is 120 pixels wide by 240 pixels high.

    Copy and paste the following HTML into your website and enjoy!

Order toll-free weekdays 10am thru 10pm EST by phone: 1-888-395-0572 (Lines are closed on holidays & weekends.)
Customer Service | My Account | Track My Orders | Return Policy | Request Free Catalog | Email Newsletter

Gift Certificates
RSS Feeds
About Us
Contact Us
Terms Of Use
Privacy Policy