PeopleSoft PeopleTools SQR Training Rel 8.53

PeopleSoft PeopleTools SQR Training Rel 8.53

Introduction:

PeopleSoft PeopleTools SQR Training Rel 8.53 Course by ENO

This five-day PeopleSoft PeopleTools SQR Training Rel 8.53 equips you with the knowledge and skills to understand the fundamentals of the Structured Query Report (SQR) language and to use SQR for PeopleSoft for reporting and batch processing.

PeopleSoft PeopleTools SQR Training Rel 8.53Related Courses:

Prerequisites:

PeopleSoft PeopleTools II Rel 8.53 Ed 1
An understanding of programming basics
PeopleSoft PeopleTools I Rel 8.53 Ed 1
Familiarity with SQL

Duration: 5 days

Customize It:

With onsite Training, courses can be scheduled on a date that is convenient for you, and because they can be scheduled at your location, you don’t incur travel costs and students won’t be away from home. Onsite classes can also be tailored to meet your needs. You might shorten a 5-day class into a 3-day class, or combine portions of several related courses into a single course, or have the instructor vary the emphasis of topics depending on your staff’s and site’s requirements.

Audience / Target Group:

Application Developers
Developer
Reports Developer

What You Will Learn:

Perform reporting and batch processing.
Format reports, use variables and write procedures to develop modular reusable code.
Use an array and business chart.
Produce multiple reports and create dynamic SQL.
Understand the fundamentals of the Structured Query Report (SQR) language.
Use interoperability features, National Language Support and HTML.
Develop modular reusable code and prompt for user input.

Skills Gain:

Using HTML and Miscellaneous Functions
Exploring an SQR Program File
Creating Multiple Reports
Using Interoperability Features
Printing in SQR
Using SQR Variables and Program Flow Commands
Advanced Printing with SQR
Using Arrays
Using Business Chart Graphics
Implementing SQC Files and Local Procedures
Working with External Data
Using Lookup Tables
Working with External Data
Prompting for User Input
Creating Dynamic SQL

Course Content:

Getting Started with SQL and SQR

Using Oracle SQL Developer
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

Printing in 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

Using Arrays

Explaining an Array
Using Array Commands
Programming Errors with Arrays

Using Business Chart Graphics

Explaining the Components of the SQR Chart
Inserting Business Charts

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

Using Printer Commands

Specifying default values for Printer
Changing Printer characteristics at Run time

Creating Multiple Reports

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

Using Interoperability Features

Calling SQR from another application
Invoking an external application API by using the ufunc.c interface

Using HTML and Miscellaneous Functions

Generating HTML output from an SQR
Using additional SQR built-in functions for handling environment parameters, and other features

Debugging and Tuning SQR Programs

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

Request More Information

Time Frame: 0-3 Months4-12 Months

No Comments Yet.

Leave a comment