SQR Rel 8.48 :: PPL-SQR

start > courses and registration > training feature sheet

code.

PPL-SQR

length.

5 days

type.

Instructor-Led

partner.

Oracle

price.

$3,750

This five-day course equips students with the knowledge and skills required to understand the fundamentals of the Structured Query Report (SQR) language and to use SQR for PeopleSoft for reporting and batch processing. Specifically, students learn how to format reports, use variables, run SQR programs from the PeopleSoft Process Scheduler and the desktop, write procedures to develop modular reusable code, prompt for user input, produce multiple reports, and create dynamic SQL among other topics.

The course emphasizes the importance of SQL and the PeopleSoft application database structure, and how the two can be used in the SQR programming environment. The course provides participants with practical solutions to business rules-related requests for reports.

Learn To:

	Create, edit, run, and debug SQR programs
	Format your report output
	Write procedures thereby developing modular, reusable code
	Add SQR processes to the Process Scheduler
	Use runtime parameters to create dynamic SQL
	Develop SQR programs that generate multiple reports

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

	Application Developers
	Developer
	Reports Developer
	Technical Consultant

prerequisites

Required Prerequisites:

PeopleTools I Rel 8.48

skills gained

You will learn to:

	Describe the features of SQR
	Run an SQR program from the Process Scheduler and the desktop
	Explain the five sections of an SQR program
	Use explicit and implicit printing
	Use SQR variables and program flow control
	Manipulate string, date, and numeric data
	Use advanced printing features of SQR
	Use SQC files to develop modular, reusable code
	Create and use lookup tables
	Write data to, and read data from, a file
	Add an SQR process to the Process Scheduler
	Write an SQR program that accepts user input
	Create dynamic SQL
	Write an SQR program that generates multiple reports
	Analyze and tune SQL statements and SQR programs

suggested prerequisites:

	Familiarity with SQL
	An understanding of programming basics

related courses, exams and materials

	before related training and products

PeopleTools I Rel 8.48

course content details

	Getting Started with SQL and SQR

	Using the Microsoft SQL Server Query Analyzer
	Writing SQL Statements
	Running SQR Programs from the Process Scheduler
	Running SQR Programs from the Desktop

	Exploring an SQR Program File

	Viewing a Page as a Grid
	Describing the Processing Sequence
	Writing and Editing SQR Programs
	Reading an SQR Program
	Finding Answers to Questions About SQR

	Printing with SQR

	Using Explicit and Implicit Printing
	Using Formatting Options
	Applying Edit Masks

	Using SQR Variables and Program Flow Commands

	Identifying SQR Variables
	Declaring Variables
	Using Assignment Statements
	Using Control Statements and Structures

	Manipulating String, Date, and Numeric Data

	Manipulating String Data
	Manipulating Date Data
	Working with Numbers

	Advanced Printing with SQR

	Modifying the Page Appearance
	Using Graphic Commands
	Including Images
	Using On-Break Processing

	Implementing SQC Files and Local Procedures

	Reading SQC Files
	Using SQC Procedures
	Writing Local Procedures

	Using Lookup Tables

	Creating and Loading Lookup Tables
	Retrieving Data from Lookup Tables

	Working with External Data

	Opening and Closing Files
	Reading from and Writing to Files
	Checking Referential Integrity when Working with External Data
	Using SQL Paragraphs to Update the Database
	Handling SQL Error Conditions

	Adding an SQR Program to the Process Scheduler

	Describing SQR Process Type Definitions
	10 Steps to Adding an SQR Process
	Identifying Standard Records and Pages
	Registering a Component
	Defining a Process
	Applying Process Security

	Prompting for User Input

	Using the INPUT Command
	Obtaining User Input with the Process Scheduler

	Creating Dynamic SQL

	Defining Static SQL
	Constructing Dynamic SQL

	Creating Multiple Reports

	Describing Multiple Reports
	Declaring Layouts and Reports
	Specifying Headings and Footings for Specific Reports
	Setting the Multiple Reports Flag

	Debugging and Tuning SQR Programs

	Debugging in SQR
	Using the DISPLAY and SHOW Commands
	Modifying pssqr.ini
	Designing for Performance