PS Mixed - Differences between State and temporary records?

GeekInterview.com > Interview Questions > Peoplesoft > PS Mixed

Go To First | Previous Question | Next Question

PS Mixed | Question 7 of 200

Differences between State and temporary records?

Total Answers and Comments: 6

Last Update: June 01, 2006

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

June 21, 2005 01:37:06

Vaibhav

RE: Differences between State and temporary records?

1. State record at any point of time has only single line information as it's driven by the Process_Instance a skey field. While temp table can have multiple rows.
2. State record had only single instance while the temp table can have maximum of 99 instance.
3. State record is used for restart logic.
4. State record can be used for dynamically calling AE section by adding AE_SECTION AE_APPLID as fields. Temp table can not be used.

Is this answer useful? Yes | No

July 21, 2005 09:08:34

shail

RE: Differences between State and temporary records?

In the above comment by Vaibhav State record is used for restart logic Temp records can also be used for restart logic. That should not be counted as a diff. FYI.

Temp tables are used for set processing kind of things whereas state records for row processing

Is this answer useful? Yes | No

January 11, 2006 06:22:43

Vaibhav

RE: Differences between State and temp records.

The Temp table data is available only for the duration of run. Hence when the program is aborted the data stored in Temp table is lost and you can not restart the program from that particular point. Hence the statement I used is correct that State record can only be used for re-start logic.

Is this answer useful? Yes | No

April 19, 2006 05:01:19

anita

RE: Differences between State and temp records.

what is set processing and row processing?

also why is it said that once the process is aborted the temp table data gets lost? it s a table afterall and until the table is explicitly truncated we can retrieve the values right?

also can someone tell me in layman language what restart logic is please?

Is this answer useful? Yes | No

April 26, 2006 11:47:45

peoplesoftfirendly

RE: Differences between State and temp records.

This is in addition to all the replies above -

If you create a sql table as State Record - data will be stored in the database. If at any point of time App Engine programs stops you can continue from that point on provided Restart is enabled. This is called the restart logic. With restart enabled you don't have to run app. engine program all over again. For this to be true state record cannot be a derived record. It has to be a sql table.

Temp. table is primarily used for set processing. If there are several users running the program at the same time copies of tables are created inorder to process in parallel. Temp. table lives only until the program runs and is dissolved immediately after.

Is this answer useful? Yes | No

June 01, 2006 02:41:38

nilesh

RE: Differences between State and temp records.

purpose of Temp record is diffrent that is parallel processing not the restart logic.and it's wright that state record can be used for restart logic becoz it have last row processed.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank