How do I use PeopleCode in SQL?

How do I use PeopleCode in SQL?

In AppDesigner create a new SQL object and drop the SQL in. In Peoplebooks read up on the SQL class. Instantiate a SQL object, bind in you relevant person Id variable and the SQL should auto-execute. Create an SQL definition with the SQL text and in PeopleCode do something like this.

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 I schedule a process using Peoplecode?

The process scheduler provides a good standard way to launch a process. You simply add a subpage to your run control page, and the delivered “Run” button does all of the work for you.

How do I get the current date in PeopleCode?

7 Answers. }PeopleCode. select to_char(sysdate,’dd’) from dual; should get you the day.

How do you schedule an application engine in Peoplesoft?

If you need to schedule this in Peoplesoft itself. Check if you have access to People tools –> Processes option in the main menu. A process definition needs to be created for this particular AE process and schedule it. Check the people books for scheduling with detailed information.

What is derived work record in PeopleSoft?

Derived/Work Select to define the record definition as a temporary workspace to use during online page processing. A derived or work record is not stored in the database, so you do not build it.

Is PeopleCode object oriented?

PeopleCode is a proprietary object-oriented programming language used to express business logic for PeopleSoft applications. Syntactically, PeopleCode is similar to other programming languages, and can be found in both loosely-typed and strongly-typed forms.

How do I pass data from a component buffer to PeopleCode?

An Application Engine program can access only state records or other objects you create in PeopleCode. However, you do have several options for passing data from a component buffer to an Application Engine program: you can use the CallAppEngine PeopleCode function or you can define global variables.

What is the SQL class 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.

Why do we need buffers in PeopleSoft?

So now if the record is used as a grid on some page/component, every time you update the field of any of the row, this will help you in determining the correct row to run the edits. So this is all about buffers in PeopleSoft and now you are a master of component buffer and data buffer.

What is an example of data buffer hierarchy?

Data Buffer Hierarchy Examples Image: EMPLOYEE_CHECKLIST repatriation checklist The following EMPLOYEE_CHECKLIST image is an example of data buffer hierarchy. Suppose you want to access the BRIEFING_STATUSfield at level two of the following page: First, determine where your code is running.