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