Differences between State and temporary records?

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.

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






SHARE

peoplesoft

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Phaniraavi@gmail.com