|
SQR in Peoplesoft & Other Applications 2nd Edition
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.
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
|
