SQR in PeopleSoft and other applications

PeopleSoft v. 8

Galina Landres, Vlad Landres

692 pages, parution le 22/10/2003 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

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 new language liberates programmers from the constraints of SQL and allows them to concentrate on the application aspects of their programs. This new edition covers all SQR language elements and features, showing developers the best ways of utilizing the languages capabilities and demonstrating good programming habits. Written in a "let's do it together" tutorial style, this book starts with the basics and leads users toward a full understanding of the subject. Part one describes the SQR language with all of its features, while part two covers all aspects of interaction between SQR programs and PeopleSoft. This makes the book a working manual for both SQR programmers and PeopleSoft developers.

This book

Reflects current version of PeopleSoft v.8
Shows how to integrate SQR programs and PeopleSoft
Provides 100+ examples of real life source code

Audience

Programmers responsible for the development and support of SQR-based applications
PeopleSoft developers who write and maintain SQR programs designed to function in the PeopleSoft environment
PeopleSoft functional users, project leaders and managers
Database administrators

SQR basics
- Introducing SQR
- Structured Query Language
- Getting started
- SQR data elements and data manipulations
- Basic program structure
- Working with data from a database
- Taking full advantage of SQL
- Loops and decision logic in SQR
- Enhancing your report
Advanced features of SQR
- Using break logic in your SQR program
- Run-time and compile-time variables
- Working with arrays
- Creating multiple reports
- Creating SQR Portable Files
- Generating letters
- Using graphics
- Working with flat files
- Interacting with operating systems and other applications
- Internet enabling
- Debugging techniques
- Good programming practices
SQR and PeopleSoft
- Running SQR in PeopleSoft applications
- Attaching an SQR program to PeopleSoft objects
- Making an SQR program API Aware
- Accepting input parameters from PeopleSoft pages
- Using process recurrences and job streams
- Implementing security in SQR
- Working with effective-dated tables
Appendix A Sample database
Appendix B SQR command line flags
Appendix C Built-in functions
Appendix D SQR command syntax
Bibliography
Index

L'auteur - Galina Landres

Galina Landres has developed IS solutions for Waldenbooks, Entex, Coopers & Lybrand, Seagram, and Universal Studios.

L'auteur - Vlad Landres

Vlad Landres has 25 years experience with systems design, programming, and project management for the banking and insurance industries. Both live in Stamford, Connecticut.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Manning Publications
Auteur(s)	Galina Landres, Vlad Landres
Parution	22/10/2003
Édition	2^eme édition
Nb. de pages	692
Format	18,7 x 23,5
Couverture	Broché
Poids	1155g
Intérieur	Noir et Blanc
EAN13	9781932394009
ISBN13	978-1-932394-00-9