AESection Example
Assume that you have a template section called TEMPLATE in the Application Engine program called MY_APPL. The template looks like this:
Steps |
Actions |
---|---|
NewStep1 |
DO When DO Select SQL |
NewStep2 |
DO Select CallSection |
Also, assume that you have a base section called DYN_SECT in the Application Engine program called RULES. When you start, this section looks like this:
Steps |
Actions |
---|---|
Step1 |
DO Select Call Section DO Unit |
Step2 |
Call Section |
Here’s the PeopleCode:
Local AESection &Section;
&Section = GetAESection("RULES", "DYN_SECT");
/* Open the base section */
&Section.SetTemplate("MY_APPL", "TEMPLATE");
/* Set the template section */
&Section.AddStep("NewStep2");
/* Insert NewStep2 */
/* Do some SQL stuff here */
&Section.SetSQL("DO_SELECT", &MySql);
/* Modify the SQL in the added step */
&Section.Save();
&Section.Close();
/* Save and close */
The base section looks like this after execution:
Steps |
Actions |
---|---|
NewStep2 |
DO Select Call Section |
Note: The existing steps in the base section have been overwritten by the new step from the template section.