Overview

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.

Full Product Details

Author:   Galina Landres
Publisher:   Manning Publications
Imprint:   Manning Publications
Edition:   2nd edition
Dimensions:   Width: 18.80cm , Height: 3.60cm , Length: 23.40cm
Weight:   1.161kg
ISBN:  

9781932394009

ISBN 10:   1932394001
Pages:   660
Publication Date:   01 September 2003
Audience:   College/higher education ,  Tertiary & Higher Education
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

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

Reviews

Author Information

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-yearsA A' 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

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions