How do you exit an application engine in PeopleSoft?

Posted on by Muna Meyer

How do you exit an application engine in PeopleSoft?

The exit values work in conjunction with the “On Return” setting in the AE program step for the PeopleCode Action. If set to “Skip Step” then exit(1) will cause the remainder of this step to be skipped. If set to “Abort” then exit(1) will cause the program to end with No Success.

What is SQLExec in PeopleCode?

PeopleCode provides the SQL class for accessing these SQL definitions in your PeopleCode program at runtime. The SQL class provides capability beyond that offered by SQLExec. Unlike SQLExec, which fetches just the first SELECTed row, operations for the SQL class allow iteration over all rows fetched.

How do you exit a loop in PeopleCode?

You can exit a For loop using a Break statement.

What is Exit 0 and Exit 1 in PeopleCode?

Difference between Exit(1) and Exit(0)? In an App Engine PeopleCode, it’s not uncommon to see code that works on the following logic. You have a condition and if it’s TRUE, you want Exit(1) to execute. If the condition is FALSE, you would like Exit(0) to execute.

How do I skip a Peoplesoft search page?

Below are a few ways to bypass the search record….Set the INSTALLATION table as the search record

  1. The component processor will not show the search record.
  2. The component processor will load level zero with the first row returned by the database for any tables and views.

How do you find the difference between two dates in PeopleCode?

Finding Number of Days Between Two Dates

  1. %DateAdd(from_date, nbr_days_to_add) – You can use negative numbers in the second parameter.
  2. %DateDiff(from_date, to_date)
  3. %DateTimeDiff(from_datetime, to_datetime) – Gives the difference between two date/times in minutes.

How do you use an array in PeopleCode?

Populating an Array

  1. Use CreateArray when you initially create the array: Local Array of Number &MyArray &MyArray = CreateArray(100, 200, 300);
  2. Assign values to the elements of the array:
  3. Use the Push method to add items to the end of the array:
  4. Use the Unshift method to add items to the beginning of the array:

How do you comment PeopleCode?

You insert comments into PeopleCode in these ways: You can insert C-style comments that span multiple lines with /* at the beginning and */ at the end. You can use a Rem (remark) statement for commenting. Put a semicolon at the end of a Rem comment.