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.
"synopsis" may belong to another edition of this title.
About the Author:
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.
"About this title" may belong to another edition of this title.
Other Popular Editions of the Same Title
Top Search Results from the AbeBooks Marketplace
1. Sqr in PeopleSoft and Other Applications: PeopleSoft V.8 (Paperback)
ISBN 10: 1932394001
ISBN 13: 9781932394009
New
Paperback
Quantity Available: 1
Seller:
Rating
Book Description Paperback. Condition: New. 2nd. Paperback. Programmers, database developers, administrators responsible for PeopleSoft support, functional users, and project managers are discovering SQR, or Structured Query Report Writer, which ha.Shipping may be from multiple locations in the US or from the UK, depending on stock availability. 660 pages. 1.139. Seller Inventory # 9781932394009
Buy New
US$ 58.83
Convert Currency
2. SQR in PeopleSoft and other applications, Second Edition (Paperback)
Published by
Manning Publications, United States
(2003)
ISBN 10: 1932394001
ISBN 13: 9781932394009
New
Paperback
Quantity Available: 1
Seller:
Rating
Book Description Manning Publications, United States, 2003. Paperback. Condition: New. 2nd edition. Language: English . Brand New Book. SQR in PeopleSoft and Other Applications Second Edition is a revised edition of the same book upgraded to the current versions of SQR and PeopleSoft. It covers the SQR language, the integration between SQR and PeopleSoft 8, and provides 100+ examples of close to real life code. SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v. 8 is a revised edition of the same book upgraded to the current versions of SQR (version 6) and PeopleSoft (version 8). Written in 1999, the original book has been the best seller in its category. It has earned enthusiasm in the SQR and PeopleSoft community but has fallen behind the current versions of both SQR and PeopleSoft. This new edition is finally filling the void. Written in a let s do it together tutorial style, the book starts with the basics and leads the reader towards a full understanding of both SQR and its integration with PeopleSoft 8. The book is organized into three parts. Part 1 covers the SQR program structure, output page structure, main language elements, and controlling the output layout. Part 2 addresses page breaks (one of the most difficult topics in SQR), arrays, working with multiple reports, graphics, interaction between SQR and other tools, Internet enabling, debugging techniques, and recommended programming practices. Part 3 covers all aspects of integrating SQR programs into PeopleSoft 8 environment, including interaction with the Process Scheduler, creating pages and components, defining security for various objects, calling SQR code from PeopleSoft online pages and how to make an SQR program PeopleSoft API-enabled. The four book s appendices include the complete syntax of all SQR commands and built-in functions, SQR command flags and describe all tables (modeled after the PeopleSoft HRMS database) used in the book s examples. Over a hundred of the book s examples contain lots of code covering the most typical tasks that any developer may encounter. Readers can download these code examples from the publisher s web site and use them with very little customization.Included:Complete SQR Command SyntaxHundred+ Practical ExamplesHow to Integrate Your SQR Programs with PeopleSoftCovers SQR Version 6 and PeopleSoft Version 8. Seller Inventory # AAC9781932394009
Buy New
US$ 60.35
Convert Currency
3. SQR in PeopleSoft and other applications, Second Edition (Paperback)
Published by
Manning Publications, United States
(2003)
ISBN 10: 1932394001
ISBN 13: 9781932394009
New
Paperback
Quantity Available: 1
Seller:
Rating
Book Description Manning Publications, United States, 2003. Paperback. Condition: New. 2nd edition. Language: English . Brand New Book. SQR in PeopleSoft and Other Applications Second Edition is a revised edition of the same book upgraded to the current versions of SQR and PeopleSoft. It covers the SQR language, the integration between SQR and PeopleSoft 8, and provides 100+ examples of close to real life code. SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v. 8 is a revised edition of the same book upgraded to the current versions of SQR (version 6) and PeopleSoft (version 8). Written in 1999, the original book has been the best seller in its category. It has earned enthusiasm in the SQR and PeopleSoft community but has fallen behind the current versions of both SQR and PeopleSoft. This new edition is finally filling the void. Written in a let s do it together tutorial style, the book starts with the basics and leads the reader towards a full understanding of both SQR and its integration with PeopleSoft 8. The book is organized into three parts. Part 1 covers the SQR program structure, output page structure, main language elements, and controlling the output layout. Part 2 addresses page breaks (one of the most difficult topics in SQR), arrays, working with multiple reports, graphics, interaction between SQR and other tools, Internet enabling, debugging techniques, and recommended programming practices. Part 3 covers all aspects of integrating SQR programs into PeopleSoft 8 environment, including interaction with the Process Scheduler, creating pages and components, defining security for various objects, calling SQR code from PeopleSoft online pages and how to make an SQR program PeopleSoft API-enabled. The four book s appendices include the complete syntax of all SQR commands and built-in functions, SQR command flags and describe all tables (modeled after the PeopleSoft HRMS database) used in the book s examples. Over a hundred of the book s examples contain lots of code covering the most typical tasks that any developer may encounter. Readers can download these code examples from the publisher s web site and use them with very little customization.Included:Complete SQR Command SyntaxHundred+ Practical ExamplesHow to Integrate Your SQR Programs with PeopleSoftCovers SQR Version 6 and PeopleSoft Version 8. Seller Inventory # AAC9781932394009
Buy New
US$ 62.56
Convert Currency
4. SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8
Published by
Manning Publications
(2003)
ISBN 10: 1932394001
ISBN 13: 9781932394009
New
Paperback
Quantity Available: 2
Seller:
Rating
Book Description Manning Publications, 2003. Paperback. Condition: New. Never used!. Seller Inventory # P111932394001
Buy New
US$ 62.99
Convert Currency
5. SQR in PeopleSoft and Other Applications
Published by
Manning Publications 2003-09-01, Greenwich, Conn. |[Great Britain]
(2003)
ISBN 10: 1932394001
ISBN 13: 9781932394009
New
paperback
Quantity Available: 1
Seller:
Rating
Book Description Manning Publications 2003-09-01, Greenwich, Conn. |[Great Britain], 2003. paperback. Condition: New. Seller Inventory # 9781932394009
Buy New
US$ 56.57
Convert Currency
6. SQR in PeopleSoft and other applications, Second Edition
Published by
Manning Publications
ISBN 10: 1932394001
ISBN 13: 9781932394009
New
Paperback
Quantity Available: 7
Seller:
Rating
Book Description Manning Publications. Paperback. Condition: New. New copy - Usually dispatched within 2 working days. Seller Inventory # B9781932394009
Buy New
US$ 61.02
Convert Currency
7. SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8
Published by
Manning Publications
(2003)
ISBN 10: 1932394001
ISBN 13: 9781932394009
New
Softcover
Quantity Available: 1
Seller:
Rating
Book Description Manning Publications, 2003. Condition: New. book. Seller Inventory # M1932394001
Buy New
US$ 75.10
Convert Currency
8. SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8
Published by
Manning Publications
ISBN 10: 1932394001
ISBN 13: 9781932394009
New
PAPERBACK
Quantity Available: 7
Seller:
Rating
Book Description Manning Publications. PAPERBACK. Condition: New. 1932394001 Special order direct from the distributor. Seller Inventory # ING9781932394009
Buy New
US$ 69.95
Convert Currency
9. Sqr in PeopleSoft and Other Applications: PeopleSoft V.8
Published by
Manning Publications
ISBN 10: 1932394001
ISBN 13: 9781932394009
New
Paperback
Quantity Available: 6
Seller:
Rating
Book Description Manning Publications. Paperback. Condition: New. 660 pages. Dimensions: 8.9in. x 7.6in. x 1.9in.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 languages 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. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Seller Inventory # 9781932394009
Buy New
US$ 78.69
Convert Currency
10. SQR IN PEOPLESOFT AND OTHER APPL
ISBN 10: 1932394001
ISBN 13: 9781932394009
New
Quantity Available: 1
Seller:
Rating
Book Description Condition: New. New. Seller Inventory # S-1932394001
Buy New
US$ 94.37
Convert Currency