Tag Archives: SQL
Application Engine Action Plugins – The Complete Guide
An Application Engine Action Plugin is a new PeopleTools feature that can be used to alter SQL or PeopleCode actions in any App Engine program. . This guide covers all aspects of configuring App Engine plugins.
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.
Use Temp Tables to Easily Insert Effective-dated Rows
Have you come across a situation where you had to insert a large number of effective dated rows into a table? Here’s an easy way to accomplish this using Temp tables. Keep reading for a quick tip.
Process Remains in Posting State?
Your process has a Distribution Status that says “Posting”, what would you do now? This post has some simple SQL statements that can do the trick.
Concatenating Rows in SQL Server
Have you ever felt the need to concatenate multiple rows against a particular field into a single row? We can do this sort of row concatenation right within SQL Server rather than bringing the output into Excel and then doing it. Here’s how!
Updating multiple fields with values from another table
While carrying out day-to-day support for PeopleSoft systems, we often encounter cases where fields in a record must be updated with values from another table. In this post, we will… Read more
