What is Meta-SQL in PeopleSoft?
Meta-SQL is a great way to abstract SQL logic and ensure consistency in your SQL definitions. It isn’t just for database platform independence, it is actually a better way to write SQL for PeopleSoft.
What is the use of state record in PeopleSoft?
State records are used in Application Engine programs to keep track of useful information through the life of a program. PeopleSoft uses the concept of a record (table) to store this information.
Do actions in PeopleSoft application engine?
Do When Action The Do When is true when the sql inside the action returns any one row. If the Do When action is true, then the application engine will execute actions following the Do When, otherwise it will skip to next Step.
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.
Do select VS do while?
5 Answers. The condition in an app engine DO-WHILE contruct is true if the associated SQL SELECT statement returns any rows. Any subsequent action executes until the SQL statement doesn’t return any more rows. In contrast, the DO-UNTIL construct executes the actions first and then runs the SQL.
What is PeopleSoft file layout?
A file layout is a definition that represents the data structure of a flat (text) file to be processed. When reading from or writing to a flat file, PeopleCode can use a file layout as a template to identify and correctly process the records and fields of the file.
Where can I find a complete PeopleSoft Meta-SQL reference?
This PeopleBook discusses only meta-SQL elements that can be used in Application Engine. You can find a complete reference to all PeopleSoft meta-SQL elements in PeopleTools 8.52 PeopleBook: PeopleCode Language Reference. This section provides an overview of PeopleCode and Application Engine programs and discusses how to:
What is metadata in PeopleSoft analytical applications?
The PeopleSoft Analytical Applications are supported by a framework of metadata. Metadata defines everything from table and data structures to rules for running processes. Metadata is central to the entire Analytical Applications product suite.
Can I use this Meta-SQL in application engine PeopleCode actions?
This meta-SQL can only be used in PeopleCode programs, not in Application Engine PeopleCode actions. Also, this meta-SQL is not implemented for COBOL. Specify the name of the record to be used for inserting.
What are the metadata layers in PeopleSoft EPM?
The metadata structure that is used by the PeopleSoft EPM engines is built in several layers or levels, each dependent on the layer below it. The following table lists the metadata layers that are found in PeopleSoft EPM in order from the lowest to the highest level: Defines the lowest level of EPM metadata table objects.