Application Engine Rel 8.48

Scheduled Dates Locations filtered. Show all UK course locations.

Course Overview

This 4-day course teaches students how to use PeopleSoft Application Engine to program batch solutions to manage the data in a PeopleSoft database. You will learn to use Application Engine to execute existing programs, to modify existing programs, and to create new programs. You will use SQL, PeopleCode, and flow controls to solve business-based batch processing requirements.

Course objectives:

• Use the Application Engine Designer to write, test, and debug Application Engine programs
• Develop robust Application Engine programs
• Schedule the automatic execution of Application Engine programs
• Monitor and tune Application Engine performance

Audience

• Application Developers
• Developer
• Support Engineer
• System Analysts
• Technical Consultant
• Technical Administrator

Skills Gained

Delegates will learn to:

• Create batch solutions to manage data
• Use Application Engine as a tool for integration
• Use Application Engine to execute and modify existing programs
• Use Application Engine to create new programs

Prerequisites

• Comprehensive understanding of the Application Designer

Suggested Prerequisites:

• Basic understanding of PeopleCode
• Experience with general batch processing tools
• Experience with using tools to integrate applications
• Experience with application development

Course Outline

Introducing Application Engine Designer

• Describing Student Workstation Resources
• Using Application Engine Designer
• Describing Application Engine Program Structure
• Building Application Engine Programs
• Adding Markets and Filters to Application Engine Program Sections
• Setting Application Engine Program Properties
• Testing Application Engine Programs

Using State Records

• Describing the Function of State Records
• Executing an Application Engine Program Using the Developer's Shortcut
• Modifying Application Engine Programs to use State Records
• Adding Sections and Steps to Existing Application Engine Programs
• Using Meta-SQL in Application Engine Programs

Testing and Debugging

• Testing Application Engine Programs
• Using the Process Monitor
• Using Application Engine Traces
• Using the Application Engine Debugger
• Testing With Application Engine Restart

Using the Do Select Action

• Describing Do Select
• Using Select and Fetch
• Using Reselect
• Using Restartable
• Developing an Application Engine Program Using Do Select

Incorporating Conditional Processing

• Defining Do Actions
• Explaining Conditional Statements in SQL
• Explaining Do Action Program Flow
• Designing a Program Using Conditional Processing
• Using Application Engine Libraries

Using PeopleCode with Application Engine

• Identifying How to use PeopleCode in Application Engine Programs
• Inserting PeopleCode into an Application Engine Program
• Enabling Dynamic Calls

Using Set Processing

• Describing Set Processing
• Modifying a Program to use Set Processing

Using Temporary Tables

• Describing Parallel Processing
• Implementing Parallel Processing
• Using Meta-SQL with Parallel Processing
• Describing Run-Time Allocation

Executing Application Engine Programs

• Executing an Application Engine Program Using a Push Button
• Executing an Application Program with the Process Scheduler
• Executing an Application Engine Program with a Command Script

Creating Process Definitions for Application Engine

• Identify the Process Types used with Application Engine
• Creating Application Engine Process Definitions
• Implementing an Application Engine Program with No User Inputs
• Implementing an Application Engine Program With User Inputs

Using PSDAEMON

• Describing PSDAEMON
• Describing a Daemon-Only Application Engine Program
• Defining Daemon Groups
• Monitoring a Daemon Process

Measuring Application Engine Performance

• Describing Traces
• Passing Trace Values to PSAE.EXE
• Interpreting Application Engine Trace Data
• Interpreting the PeopleTools Trace
• Describing Advanced Trace Options

Tuning Application Engine Programs

• Describing the Process of Performance Tuning
• Identifying Application Level Tuning Opportunities
• Explaining the Performance Impact of PeopleCode
• Describing How Do Flow Control Affects Program Performance
• Explaining Database-Level Tuning Considerations

Application Engine Rel 8.48 / D17585GC20