- ホーム
- > 洋書
- > 英文書
- > Computer / Languages
Full Description
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 Syntax Hundred+ Practical Examples How to Integrate Your SQR Programs with PeopleSoft Covers SQR Version 6 and PeopleSoft Version 8
Contents
preface introduction 1 Introducing SQR 3 2 Structured Query Language 11 3 Getting started 32 4 SQR data elements and data manipulations 41 5 Basic program structure 65 6 Working with data from a database 79 7 Taking full advantage of SQL 95 8 Loops and decision logic in SQR 102 9 Enhancing your report 111 10 Using break logic in your SQR program 135 11 Run-time and compile-time variables 159 12 Working with arrays 175 13 Creating multiple reports 197 14 Creating SQR Portable Files 211 15 Generating letters 219 16 Using graphics 237 17 Working with flat files 256 18 Interacting with operating systems and other applications 277 19 Internet enabling 310 20 Debugging techniques 348 21 Good programming practices 356 22 Running SQR in PeopleSoft applications 377 23 Attaching an SQR program to PeopleSoft objects 400 24 Making an SQR program API Aware 450 25 Accepting input parameters from PeopleSoft pages 465 26 Using process recurrences and job streams 492 27 Implementing security in SQR 516 28 Working with effective-dated tables 523 appendix A Sample database 549 appendix B SQR command line flags 557 appendix C Built-in functions 568 appendix D SQR command syntax 586 bibliography 650 index 651
