sharry

 Profile Answers by sharry 

• Dec 13th, 2007

 

Temp Tables:
The are used to store the immediate values during the processing of the AE.
They help in batch processing by creating multiple instances and there by facilitating parallel processing.
If used properly they can greatly improve the performance.
State Records:
They are used to pass on values from one section/step/prog to the other.
There can be a max of 200 state rec that can be used in a single AE but only one of them can be default.state record name must end with _AET.

sharry

 Profile Answers by sharry 

• Dec 13th, 2007

 

For state record...

State record is used for providing the variables, database fields to different sections of the application engine. Scope of the state record is limited to the application engine program. AE can have multiple state records, but can have only one as a default state record.

It can be physical or derived work record. Physical record can be used when you have a restart logic and when you have disables the restart logic derived and work record can be used.

The naming convention is, it must end with _AET identifier and process instance should be the one and the only key for the state record, so that application will identify the record as a state record.

nsivudu

 Profile Answers by nsivudu 

• Mar 28th, 2008

 

Temporary table can be used in application engine programs to support parallel processing.

The state record will be used to pass variable information between two application engine sections
          ..........Sivananda Reddy...........

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• Oct 28th, 2009

 

Temporary table: To allow other users to access the same table that has been using by the AE program. These are mainly used in batch processing. These can store specific data to update without affecting the main application table. This is a database object. To increase the performance of AE program. Used to process data of tables having huge amounts of data in less time.

State record: We can use to pass variables between sections to section. Process instance is the mandatory field. We can insert the data into state record through %select, %selectinit. We can retrieve the data from the state record through %bind. The name of the state record must end with AET. When the AE program completes successfully, the row of data in the state record is deleted.

RAJ ATMAKUR

• Oct 10th, 2014

 

BOTH THE TEMP TABLES AND STATE RECORDS CAN B USED TO PASS VALUES FROM ONE STEP 2 ANOTHER OR ONE ACTION 2 ANOTHER ..

BUT THE DIFF IS,

WITH STATE RECORD -WE CAN PASS A SINGLE ROW OF DATA

-CANT B USED IN PARALLEL PROCESSING

WITH TEMP TABLES - WE CAN PASS MULTIPLE ROWS OF DATA

-CAN B USED IN PARALLEL PROCESSING

Prasad

• Jul 28th, 2017

 

State Record pass the values from section to section and step to step. it should be SQL table or derived work record. must started with _AET. process_instance is the high level key field.
During batch processing, Application Engine automatically performs all state record updates. When a program starts, it inserts a row into the state record that corresponds to the process instance assigned to that program run. Application Engine updates the record whenever a commit operation occurs. When restart is enabled and a commit occurs, all state records that have been updated in memory are written to the database, except for derived state records, which are initialized instead.
After the program completes successfully, Application Engine deletes the corresponding row in the state record. There is only one row in the state record for each process instance. Multiple programs can use the same state record, and each program has its own row based on the unique process instance key.
To set values in the state record, you use the %SELECT construct in a SQL statement or write PeopleCode that references the state field with the standard record.field notation. To reference fields in the state record, use the %BIND construct.