Question is related to Application Engine in PeopleSoft Q2As

Question is related to Application Engine in PeopleSoft

Q2.Assume there are 2 tables ABC and XYZ. Both the tables are having ROW_NUM filed with length of 3 digits. ABC is having the 5 values 699, 799, 899, 999, 299. And we are trying to insert these 5 values into XYZ table by adding 1 to each number.

Main Section

Step1

DoSelect

%Select(ROW_NUM)

SELECT ROW_NUM

FROM ABC

PeopleCode

Here I will write the Commit only for 3rd Example.

SQL

INSERT INTO XYZ

VALUES (%Bind(ROW_NUM)+1)

Step2

PeopleCode

SQLExec(\"COMMIT\");

1.What would be the program flow when

Section Level - Auto Commit – After Step is unchecked,

Step Level – Commit After is After Step.

Step Level – OnError is Abort.

2.What would be the program flow when

Section Level - Auto Commit – After Step is unchecked,

Step Level – Commit After is After Step.

Step Level – OnError is Abort.

And there is Commit statement in Step1 - PeopleCode.

SQLExec(\"COMMIT\");

Solution

Q2