Getting Started With PeopleSoft Application Engine

This chapter provides an overview of PeopleSoft Application Engine and discusses:

PeopleSoft Application Engine implementation
Other sources of information

Application Engine Overview

PeopleSoft Application Engine is a PeopleTool designed to help you develop background SQL processing programs. This tool is intended to be used by developers with knowledge of SQL, SQL tools and PeopleTools.

PeopleSoft Application Engine offers you an alternative to writing COBOL, or SQR programs for background SQL processing. While PeopleSoft Application Engine does not generate, parse, or understand SQL, it does execute SQL that you provide.

Application Engine Program Structure

PeopleSoft Application Engine Implementation

This section provides information to consider before you begin to use PeopleSoft Application Engine.

Implementation of PeopleSoft Application Engine can be divided into the following activities:

Set up properties.
Specify actions.
Create temporary table instances.
Set up debug options.
Enable application engine tracing.

Setting Up Properties

To set up PeopleSoft Application Engine properties, you perform the following steps:

Step	Reference
1. Set up program properties.	See Setting Program Properties.
2. Set up section properties.	See Setting Section Properties.
3. Set up step properties.	See Setting Step Properties.
4. Set up action properties.	See Setting Action Properties.

Specifying Actions

To modify the action properties, you perform the following steps:

Step	Reference
1. Specify SQL actions.	See Specifying SQL Actions.
2. Specify Do actions.	See Specifying Do Actions.
3. Specify PeopleCode actions.	See Specifying PeopleCode Actions.
4. Specify Call Section actions.	See Specifying Call Section Actions.
5. Specify Log Message actions.	See Specifying Log Message Actions.

Creating Temporary Table Instances

To set up temporary tables to improve performance, you perform the following steps:

Step	Reference
1. Define temporary tables.	See Defining Temporary Tables.
2. Set up the number of temporary table instances.	See Setting the Number of Temporary Table Instances.
3. Build table instances.	See Building Table Instances.

Setting Up Debugging Options

To set up debugging options for Application Engine programs, you perform the following steps:

Step	Reference
1. Enable the PeopleSoft Application Engine debugger.	See Enabling the PeopleSoft Application Engine Debugger.
2. Set up debugging options.	See Setting Debugging Options.

Enabling Application Engine Tracing

To trace Application Engine programs, you perform the following steps:

Step	Reference
1. Set command line options.	See Setting Command Line Options.
2. Set parameters in server configuration files.	See Setting Parameters in Server Configuration Files.
3. Set options in Configuration Manager	See Setting Options in PeopleSoft Configuration Manager.

Other Sources of Information

In addition to implementation considerations presented in this chapter, take advantage of all PeopleSoft sources of information, including the installation guides, release notes, and PeopleBooks.