Peoplesoft app engine do when example

App Engine

1.It is a PeopleTool and It is used to develop batch programs or online programs that perform the backed processing against the data.

2.It consists of the 2 distinct components .They are

Designer->Consists of the batch programs.

Run time Environment->To run and monitor the programs.

3.A program is a set of SQL statements.

4.It does not generate SQL or PeopleCode, but it executes SQL or PeopleCode as a part of program.

5.It is designed for batch processing where data must be processed without user interaction.

6.AE resides on database server.

APPLICATION ENGINE PROGRAM ELEMENTS:

======================================

1.PS AE consists a set of processes to execute a given task and made up of several elements.They are

i) Sections

It is a set of ordered steps that gets executed as a part of the program.The execution of the program starts with the section defined as MAIN.

Steps are the smallest unit of the program that can be commited within a program.It is used to execute the a peopleCode

command or log a message with the step.When the section gets called, its steps execute sequentiately.

iii) Actions

Multiple actions can be within a step.There are 5 multiple actions they are

DO ACTIONS:

===========

Do actions contain a SQL statements taht is designed to return the results on which subsequent actions depend.

It is equvalent to a COBOL perfrom statement.There are 4 types of Do actios they are:

1)Do While 2)DO When 3)Do Select 4)Do Until.

SQL AND CALL SECTION ARE MUTUALLY EXCLUSIVELY ACTION WHICH CANNOT BE PERFORMED ONCE AT ATIME COZ IT CAUSES DEADLOCKS

It contain a single SQL statements.There are 4 types of SQL statements.They are

1)Update 2)Delete 3)Insert 4)Select

It provides an excellent way to build dynamic SQL, perform simple if/else edits,set defaults and other operations that

Log Message:

============

Call Section:

=============

It is used to call and insert an action in the progaram or outside program.

iv) State Records

=============

It is a PeopleSoft Record that must be created and maintained by the Application Engine developer.

This record defines the fields a program uses to pass values from one action to another.

It can be either a Physical record or a work record, any no of sate records can be assosiated with a program.

Physical state records must be keyed by process instance.

APPLICATION ENGINE PROGRAM TYPES:

=================================

There are 5 types of Application Engine Programs.They are.

1.Standard->Normal entery point program.

2.Upgrade Only->used in PS Upgrade utilites.

3.Import Only->used by PS import utilites.

4.Daemon Only->A type of program which is used a daemon Process.

5.Transform Only->used to support Extensible stylesheet language Transformations(XSLT).

DAEMON PROGRAM TYPE:

1.PS AE provides a daemon process called PSDAEMON, that runs continously when PS Process Scheduler is running and it is intended for running jobs.

2.It consists of a predefined set of conditions as events.When PSDAEMON schedules a process to handle an event when the conditions are true.

3.It allows only PS AE tracing at the step and SQL levels

1.Meta-SQL is a set of predefined terms designed to replace RDBMS syntax.

2.PS meta-SQL enables us to dynamically generate portions of SQL code.(EX;--2 join 2 tables based on their common keys)

3.%select->It is ued to insert values of varibles in to sate record.

4.%bind->It is used to get values.