Application Engine Rel 8.44

Description:

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.

Learn To:

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

Audience:

Technical Consultant
System Analysts
Application Developers

Objectives:

• Describe Application Engine
• 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
• Develop and Test an Application Engine program

Prerequisites:

Required Prerequisites:
Comprehensive understanding of the Application Designer
PeopleTools II Rel 8.44
     
Suggested Prerequisites:
Basic understanding of PeopleCode
Experience with general batch processing tools
Experience with using tools to integrate applications
Experience with application development

Topics:

Introducing Application Engine Designer
Describing Student Workstation Resources
Executing an Application Engine Program
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
Creating a State Record
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
Using Select and Fetch
Using Reselect
Using Restartable
Developing an Application Engine Program Using Do Select
Building PSU_CRS_INS

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