SQR in PeopleSoft and other applications, Second Edition

Series
Manning
Author
Galina Landres  
Publisher
Pearson
Cover
Softcover
Edition
2
Language
English
Total pages
660
Pub.-date
October 2003
ISBN13
9781932394009
ISBN
1932394001


Product detail

Product Price CHF Available  
9781932394009
SQR in PeopleSoft and other applications, Second Edition
66.70 not defined

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.

Table of 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

Author

Galina Landres, a 20-year professional and PeopleSoft specialist, has developed IS solutions for Waldenbooks, Siemens, Coopers & Lybrand, Seagram and Universal Studios. Vlad Landres has 25-years¹ experience with systems design, programming and project management for the banking and insurance industries. Their consulting company is SQRLand. Galina is based in Stamford, CT