State Record Interview Question

Can we have more than one state record in single A.E?

Yes, we can have more than one state record in A.E but one should be the default state record.

Tell me what you know about state record?

State records are used to assign variables for Application Engine program. State Record used as a  worktable. The key field is Process_instance. It can be a derived work record or SQL table. No people code fires on AE state record. To restart facility we put the Process_instance field.

How will u pass a variable from one A.E. to another A.E. program?

Through state record.

What is the purpose of the State Record?

To pass the variables for the Application Engine program.

What is the other name to the State Record?

Cache record.

How many state records can be associated with an Application Engine program?

 An Application Engine program may have zero, one, or many state records. Only one state record will be the default.

Where do we associate a state record with an Application Engine program?

Program Properties.

Who creates the State Record in the Application Engine program?

The State Record must be created and maintained by the Application Engine developer.

What type of record is a state record?

      Can be a Physical record (SQL table) or a derived work record. If it is Physical table we

      should build before using this.

What is the extension to the state record?

_AET. Then only the system identifies the record as a state record.

How many rows we can have an in-state record?

We will have one row in the state record. But in case if multiple A.E programs use same state record as default state record then there will be multiple rows in the state record. i.e. one row for each record.

What field is used as the key field on a state record?

PROCESS_INSTANCE.

Why we are using the PROCESS_INSTANCE as a key field in the state record?

For the restart facility.

What Meta SQL is used to retrieve values form a state record?

%BIND.

What Meta SQL is used to store values into a state record?

%SELECT.

Can we specify the Date type field as a required field?

No, we can specify only character and numeric fields as required fields.

Is people code fires on A.E sate record?

No PeopleCode fires on an Application Engine state record.