Vaibhav
Answered On : Jun 21st, 2005
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.
1 User has rated as useful.
Login to rate this answer.
shail
Answered On : Jul 21st, 2005
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
Login to rate this answer.
Vaibhav
Answered On : Jan 11th, 2006
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.
Login to rate this answer.
anita
Answered On : Apr 19th, 2006
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?
Login to rate this answer.
peoplesoftfirendly
Answered On : Apr 26th, 2006
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.
1 User has rated as useful.
Login to rate this answer.
nilesh
Answered On : Jun 1st, 2006
hi,
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.
Login to rate this answer.
AKbar Khan
Answered On : Sep 10th, 2012
When multiple row of data need to insert in a record that is called set processing..
For Example - If we need to update pincode of a particular region we can use this processing..
first we write peoplecode in aaplication Engine, and then write update sql in "SQL" so that all rows will be updated at the same time..
When we need to insert data row by row for that purpose we use this row by row processing..
Login to rate this answer.
