List/Grid

Tag Archives: Application Engine

Insert into Longchars

Inserting into Record with Long Character Fields

Most of us here follow the good practice of executing our SQL statements directly against the database before using them within an SQLExec in PeopleCode, a view or an SQL actions in App Engines. Even after following this, we might get hit in some situations. Read on to find more.

Easily Locate Sections in Complex Application Engines

At times, Application Engines can get really big and searching for a Section within a complex App Engine can be a quite daunting. That said, PeopleSoft provides a feature to locate Sections within an App Engine with ease. Read on to figure out.

Multiple SQLs in SQL Action

Using Multiple SQL Statements in an SQL Action

While writing App Engines, we normally write one SQL statement per SQL Action. But in certain situations, we may need to change this style. This post explains how to put in multiple SQL statements into a single SQL Action.

Tracing PeopleSoft Application Engine

Application Engines are PeopleSoft’s way to tie SQL and PeopleCode into a powerful processing engine which can run synchronously as well as in batch mode. App Engines are well structured and easy to debug. In this post will see how TRACE an App Engine program.

Dynamic Call-Section

Dynamic call-section in Application Engine

Often, business logic requires us to call different sections based on occurrence of certain conditions in different scenarios and that too from the same call-section. To enable this kind of logic, we will have to make the call-section dynamic. This is how we can do it.

PeopleSoft Application Engine

PeopleSoft Application Engine is a PeopleTool used to carry out background SQL processing. Application Engines are neatly structured into blocks and offer an alternative to writing COBOL or SQR programs for background SQL processing. Application Engine has five types of programs. We can specify the type in the Program Properties dialog box for your program definition.

PeopleSoft State Records

PeopleSoft State Record

State records are used in Application Engines as a storage location for data that needs to be passed across actions. An Application Engine can have more than one state records… Read more »