Name: SQR
Course Code: ORPS17723
Duration: 5
Scheduled Dates for ORPS17723
This 5 day course equips the student with the knowledge and skills required to understand the fundamentals of SQR and to use SQR for reporting and batch processing. Specifically, the student will learn how to format reports, use variables, prompt for user input, add an SQR to the Process Scheduler, use SQCs, produce multiple reports and create dynamic SQL. The course will emphasize the importance of the database structure and SQL, and how the two can be utilized in the SQR programming environment. The course provides participants with practical solutions to business related requests.
Target Audience
Technical Consultants;
System Analysts;
Reports Developers;
Business Analysts; and
Application Developers.
Key Topics
- Examining SQR Basics
- Exploring the SQR Program File
- Printing in SQR
- Using SQR Variables and Commands
- Formatting Commands and Functions
- Advanced Printing with SQR
- Implementing SQCs and Local Procedures
- Using Lookup Tables
- Adding an SQR to the Process Scheduler
- Using Interfaces and Data Manipulation
- Analysis and Tuning
- Multiple Reports Processing
- Prompting for User Input
- Creating Dynamic SQL
Objectives
- Describe the features of SQR
- Run an SQR and explain the sections of an SQR program
- Use SQR variables, control structures, formatting commands and functions
- Debug and tune SQL statements and SQR processes
- Use SQC files to leverage the power of reusable code
- Create and use lookup tables
- Add an SQR process to the Process Scheduler
- Write an SQR report that accepts user input
- Write data to, and read data from a file
- Write an SQR report that generates multiple reports
- Describe dynamic SQL
Required Skills/Experience
- Able to run processes and reports.
- Working knowledge of PeopleSoft Architecture.
- Working knowledge of PeopleSoft Data Organization and Validation.
- Application Designer 8.1 to 8.4 Delta
- PeopleTools I 7.5 to 8.4 Delta
Fee: $3,750.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
