Homework Answers
- Application Engine first executes the Select Statement in Do While 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 People Code, 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)
- execution with rest of the Actions.
- In People Code, 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.
Add Answer to:
thanks
Can anyone please explain this sample program in Do While action MAIN Step %Select(EMPLID) SELECT...
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,...
$$$ The topic is about application Engine in PeopleSoft MAIN Step1 DoWhile %Select(EMPLID) SELECT EMPLID FROM...
$$$
The topic is about application Engine in
PeopleSoft
MAIN Step1 DoWhile %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 WHERE EMPLID IN (SELECT TOP 5 EMPLID FROM ABC ORDER BY EMPLID DESC)
Hello. can anyone solve this. i am having hard time with this. please post a solution...
Hello. can anyone solve this. i am having hard time with this. please post a solution ASAP a) Create a class named Student. Data fields for Student class include an integer Student ID, a String name, and a double CGPA. Methods include a constructor that requires values for all data fields, as well as get and set methods for each of the data fields. b) Create an application that allows a user to enter values for an array of 15...
Please finish all 6 parts. Don't need to do the measure time things, but you can do it if you wanna do it. Thanks! Write the following SQL queries and measure their execution time both with and w...
Please finish all 6 parts. Don't need to do the measure time
things, but you can do it if you wanna do it. Thanks!
Write the following SQL queries and measure their execution time both with and without using indexes 1. Count how many parts in NYC have more than 70 parts on hand 2. Count how many total parts on hand, in both NYC and SFO, are Red 3. List all the suppliers that have more total on _hand...
Hello I need a small fix in my program. I need to display the youngest student...
Hello I need a small fix in my program. I need to display the youngest student and the average age of all of the students. It is not working Thanks. #include <iostream> #include <iomanip> #include <fstream> #include <vector> #include <algorithm> using namespace std; struct Student { string firstName; char middleName; string lastName; char collegeCode; int locCode; int seqCode; int age; }; struct sort_by_age { inline bool operator() (const Student& s1, const Student& s2) { return (s1.age < s2.age); // sort...
Hello, I need to implement these small things in my C++ code. Thanks. 1- 10 characters...
Hello, I need to implement these small things in my C++ code. Thanks. 1- 10 characters student first name, 10 characters middle name, 20 characters last name, 9 characters student ID, 3 characters age, in years (3 digits) 2- Open the input file. Check for successful open. If the open failed, display an error message and return with value 1. 3- Use a pointer array to manage all the created student variables.Assume that there will not be more than 99...
Hello! I'm posting this program that is partially completed if someone can help me out, I...
Hello! I'm posting this program that is partially completed if someone can help me out, I will give you a good rating! Thanks, // You are given a partially completed program that creates a list of employees, like employees' record. // Each record has this information: employee's name, supervisors's name, department of the employee, room number. // The struct 'employeeRecord' holds information of one employee. Department is enum type. // An array of structs called 'list' is made to hold...
Please answer this problem in C++, Thank you! Read and study the sample program: "hashing with chaining using singly...
Please answer this problem in C++, Thank you! Read and study the sample program: "hashing with chaining using singly linked lists", as well as "hashing with chaining using doubly linked lists". Notice this program is complete except it doesn't include the remove function. Write the remove function and test it with the rest of the program including the given main program. Upload your C++ source file. ---Here is the referenced program: "hashing with chaining using singly linked lists". Below this...
Please!!! need help asap!!!! write a C++program to analyze a small subset of the data that...
Please!!! need help asap!!!! write a C++program to analyze a small subset of the data that has been collected. See file universities.txt .Use precisely seven parallel arrays: one for name of university, one for state, one for city, one for yearly tuition, one for enrollment, one for average freshman retention, and one for the percent of students who graduate with in six years. Note that the percentage of student accepted is not stored.An output file is opened in main() and...
Please finish all 6 parts with indexing SQL. Don't need to do the measure time things, but you can do it if you wanna do it. Thanks! Write the following SQL queries and measure their execution t...
Please finish all 6 parts with indexing SQL. Don't need to do
the measure time things, but you can do it if you wanna do it.
Thanks!
Write the following SQL queries and measure their execution time both with and without using indexes 1. Count how many parts in NYC have more than 70 parts on hand 2. Count how many total parts on hand, in both NYC and SFO, are Red 3. List all the suppliers that have more...
$$$
The topic is about application Engine in
PeopleSoft
MAIN Step1 DoWhile %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 WHERE EMPLID IN (SELECT TOP 5 EMPLID FROM ABC ORDER BY EMPLID DESC)
Please finish all 6 parts. Don't need to do the measure time
things, but you can do it if you wanna do it. Thanks!
Write the following SQL queries and measure their execution time both with and without using indexes 1. Count how many parts in NYC have more than 70 parts on hand 2. Count how many total parts on hand, in both NYC and SFO, are Red 3. List all the suppliers that have more total on _hand...
Please finish all 6 parts with indexing SQL. Don't need to do
the measure time things, but you can do it if you wanna do it.
Thanks!
Write the following SQL queries and measure their execution time both with and without using indexes 1. Count how many parts in NYC have more than 70 parts on hand 2. Count how many total parts on hand, in both NYC and SFO, are Red 3. List all the suppliers that have more...
Most questions answered within 3 hours.
-
The Baldwin Company currently has the following balances on their
balance sheet:
Total
Liabilities
$69,309
Common...
asked 29 seconds ago -
A quiet town in Kansas has 10 people, all of whom have the same
preferences. There...
asked 6 minutes ago -
Summarize what an organization needs from a leader.
a. Analyze what might happen to an organization...
asked 8 minutes ago -
How would one critically evaluate an organizations marketing
strategies from the viewpoint of its consumers, as...
asked 7 minutes ago -
Given a standardized normal distribution (with μ = 0 and a σ =
1), what is...
asked 8 minutes ago -
Company XYZ know that replacement times for the quartz time
pieces it produces are normally distributed...
asked 22 minutes ago -
A) Write the acid-base reaction that occurs between Na2HPO4 and
NaOH
B) Write the possible reactions...
asked 36 minutes ago -
What advantages does the Natural Law Theory have in comparison
with the Divine Command Theory? Explain...
asked 42 minutes ago -
A diver comes off a board with arms straight up and legs
straight down, giving her...
asked 41 minutes ago -
Answer the following questions
In your own words, define each of these terms
- Branding, Packaging,...
asked 39 minutes ago -
Briefly discuss developments in the crude oil market and your
outlook, using the microeconomic concepts discussed...
asked 40 minutes ago -
Electrons are accelerated through potential difference of 12 V
and are bombarding the hydrogen atoms. To...
asked 43 minutes ago