ZuoTi.Pro
Question

$$$

The topic is about application Engine in PeopleSoftMAIN Step1 DoWhile %Select(EMPLID) SELECT EMPLI

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

• Application Engine first executes the Select Statement in DoWhile Action.
• Condition gets satisfies as there are 10 rows.(At least one row needed)
• Inserts first employee AA into State Record and continues the execution with rest of the Actions.
• In PeopleCode, message will be displayed as
No of Rows in ABC Table: 10
Employee ID in State Record: AA
• In SQL Action, Top 5 rows in descending order (JJ, II, HH, GG, and FF) will be deleted.
• Application Engine again executes the Select Statement.
• Condition gets satisfies as there are 5 rows.(At least one row needed)
• Inserts first employee AA into State Record and continues the execution with rest of the Actions.
• In PeopleCode, message will be displayed as
No of Rows in ABC Table: 5
Employee ID in State Record: AA
• In SQL Action, Top 5 rows in descending order (EE, DD, CC, BB, and AA) will be deleted.
• Application Engine again executes the Select Statement.
• Condition gets fail as there are no rows.(At least one row needed)
• Comes out from the Step and as there are no other section to execute, program will end.

0 0
Add a comment
Know the answer?
Add Answer to:
$$$ The topic is about application Engine in PeopleSoft MAIN Step1 DoWhile %Select(EMPLID) SELECT EMPLID FROM...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Q9. Please explain for each step in this sample Program? MAIN Step1 DoWhen %Select(EMPLID) SELECT EMPLID...

    Q9. Please explain for each step in this sample Program? MAIN Step1 DoWhen %Select(EMPLID) SELECT EMPLID FROM ABC PeopleCode SQLExec("SELECT COUNT(*) FROM ABC", &Count); MessageBox(0, "", 0, 0, "No of Rows in ABC Table: " | &Count); MessageBox(0, "", 0, 0, "Employee ID in State Record: " | CNU_AET.EMPLID.Value); SQL DELETE FROM ABC Step2 DoWhen %Select(EMPLID) SELECT EMPLID FROM ABC PeopleCode SQLExec("SELECT COUNT(*) FROM ABC", &Count); MessageBox(0, "", 0, 0, "No of Rows in ABC Table: " | &Count); MessageBox(0,...

  • thanks Can anyone please explain this sample program in Do While action MAIN Step %Select(EMPLID) SELECT...

    thanks Can anyone please explain this sample program in Do While action MAIN Step %Select(EMPLID) SELECT EM PUD FROM ABC I SQLExec("SELECT COUNT(*) FROM ABC", &Count); MessageBox(0, "", 0, 0, "No of Rows in ABC Table: " | &Count); MessageBox(0, "", 0, 0, "Employee ID in State Record: " | CNU_AET.EMPLID.Value); SQL DELETE FROM ABC WHERE EMPLID IN (SELECT TOP 5 EMPLID FROM ABC ORDER BY EMPLID DESC)

  • Question 9 (1 point) Which choice below describes the function of the following SQL statement? SELECT...

    Question 9 (1 point) Which choice below describes the function of the following SQL statement? SELECT ID, Last Name, First Name, Address FROM Members WHERE Last Name Last Name a simple query a parameterized query a compound query a wildcard query Question 10 (1 point) The correct SQL syntax to sort a table by Last Name in order of A-Z is SORT BY Last Name ASCENDING ORDER BY Last Name Down ORDER BY Last Name ASC ORDER BY Last Name...

  • Answer the following SQL study guide questions... Question 1 (1 point) Unless you assign a column...

    Answer the following SQL study guide questions... Question 1 (1 point) Unless you assign a column name in the base table. the column name in the result set is the same as the 1) unique syntax 2) column alias 3) qualification 4) all of the above Question 2 (1 point) Which clause specifies the number of rows that should be skipped before rows are returned from the result set? 1) FETCH 2) OFFSET 3) FIRST 4) NEXT Question 3 (1...

  • Create the database and tables for the database. Show all SQL statements. Include primary and foreign...

    Create the database and tables for the database. Show all SQL statements. Include primary and foreign keys. Insert data into each table. Show select statements and display the output of each table. Note:Student’s name must be inserted into table as part of the data! Perform the SQL below: Query one table and use WHERE to filter the results. The SELECT clause should have a column list, not an asterisk (*). State the purpose of the query; show the query and...

  • What happens when you try to compile and run the following code? String query = "INSERT...

    What happens when you try to compile and run the following code? String query = "INSERT INTO Invoices (InvoiceDate InvoiceTotal) "              + "VALUES ('2/10/01', '443.55')"; Statement statement = connection.createStatement(); statement.executeUpdate(query); a. A SQLException is thrown at runtime because the executeUpdate method can’t accept a String object. b. A SQLException is thrown at runtime because the SQL statement is coded incorrectly. c. An error occurs at compile time because the SQL statement is coded incorrectly. d. This code compiles and...

  • 1.What is the return value if the user try to do the following: SELECT TRUNC (65.73,-2)...

    1.What is the return value if the user try to do the following: SELECT TRUNC (65.73,-2) FROM DUAL; Select one: a. 60 b. 00 c. 0 d. 600 2.Supposed that the user uses the ff SELECT statement: what will be the possible output. SELECT GRADE AS STUDENT MARK FROM GRADE_REPORT; Select one: a. Error because of the keyword AS. b. Error because of missing “” mark. c. Will display the column GRADE rename as STUDENT MAK d. Will display all...

  • Top of Form Q1 Which of the following is a valid aggregate function in SQL? Check...

    Top of Form Q1 Which of the following is a valid aggregate function in SQL? Check only those that apply. Question 1 options: AVG LEAST COUNT MIN MOST SUM Q2 Which of the following aggregate functions will only operate on a numeric value expression? Check only those that apply: Question 2 options: MIN MAX AVG COUNT SUM Q3 When applying DISTINCT to the value being calculated in an aggregate function like COUNT, what is the effect? SELECT COUNT(DISTINCT StreetName) FROM...

  • For Microsoft Access Define the four types of Action Queries: Make-table, Update, Delete, Append What is...

    For Microsoft Access Define the four types of Action Queries: Make-table, Update, Delete, Append What is an index? What field is automatically indexed? Advantages and disadvantages? What is a macro? An action? An argument? What is a command button? What are events? Event properties? Examples of event properties? What is a submacro? How is it represented in code? Why are the InputBox function and GoToControl action useful for the FindRecord action? What is the ExportWithFormatting action typically used for? What...

  • Using SQL and the following info Question 3: Find the people who do not have Viper...

    Using SQL and the following info Question 3: Find the people who do not have Viper Certification but are still assigned to Viper class ship Find the fname, lname, and ship_instance_id for all people who do not have Viper certification but are assigned to at least one instance of a Viper class ship (this includes all variants of Viper class ships). Return a row for every ship/person combination. Order your results by fname in ascending order. Use the BSG database...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT