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.
Related posts
-
Modes of Data Transmission Posted on September 2, 2009 by Luke in Hardware. Technology // 7 Comments Talking about data transmission can get confusing sometimes, we talk of types, modes, ways,...
-
Developer information Description The First the only Whats the Brand Cheats Answers Guide for What's the Brand Game by Words Mobile. Download Now! Solve Whats the Brand like a Boss. This is a...
-
Best answer: Basically you're asking how to become a legend. Well in order to do that, you will need to truly be unique and crazy talented. If you are a musician, you will have to be a musical...
-
Sony Xperia, Cause You Need a Smart Communicator! Sony Xperia Mobiles is one of the most prominent brands in India. They have established themselves as a value leader across various products...
-
Can you say taco? A host of new emojis landed on iPhones and iPads earlier this week with the iOS 9.1 update, including middle fingers, unicorns and tacos, leaving Android users a little left...