Differences between State and temporary records?

Showing Answers 1 - 12 of 12 Answers

Vaibhav

  • 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.

shail

  • 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

  Was this answer useful?  Yes

Vaibhav

  • 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.

  Was this answer useful?  Yes

anita

  • 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?

  Was this answer useful?  Yes

peoplesoftfirendly

  • 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.

nilesh

  • 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.

  Was this answer useful?  Yes

AKbar Khan

  • 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..

  Was this answer useful?  Yes

Bude

  • Nov 28th, 2014
 

State Record:
1) This is used to pass variables between section to another section.
2) The record ends with _AET.
3) Process Instance is Key field.

Temp Table:
1) Temp table is used for parallel processing.
2) Process Instance is key field.
3) The record ends with _TAO.
4) The max temp can be created upto 99 in app engine program

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions