Application Engine Rel 8.48

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 as a tool for integration
	Use Application Engine to execute and modify existing programs
	Use Application Engine to create new programs

course content details

	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