Application Engine - Part 4 - Temporary Tables and Parallel Processing

In this article we will discuss Temporary tables, their instances, parallel processing, COMMIT usage and Restarting Application Engine. This part of the Application Engine article is in continuation for Part-I in the series of Application Engine articles posted on the blog. We will be using the Application Engine AJ_AE_SAMPLE, that we developed in Part-I. We will create four different run controls to cover scenarios of Re-Startable APPLICATION ENGINE and non-ReStartable Application Engine with and without COMMIT usage. We will use an invalid Meta-SQL in one of the step after COMMIT to cause abends for all four run controls. We will then analyze the abends and resolutions. This article is going to be long as we will be covering multiple inter-connected topics. So please follow each step closely as any change could cause different results than discussed. The example has been created and tested in Peoplesoft environment with DEMO database. The major steps involved will be  1) Create two r