Understanding Global Temporary Tables

You can define Global Temporary Tables (GTTs) in the PeopleSoft Application Designer. The performance of application engine programs are enhanced on using GTTs. GTTs are temporary tables that hold data that exists only for the duration of a transaction or a session.

  • GTTs are applied to Application Engine programs running in both batch mode and online mode. The data in GTT is session specific for Application Engine programs running in batch mode and transaction specific for Application Engine programs running in online mode.

  • GTTs in online mode cannot be shared between Application Engine programs. Each Application Engine program has its own set of GTTs. Therefore, it is recommended that GTTs should not be used as Share Tables in online mode.

  • You can also define GTTs to restart-enabled batch Application Engine programs considering that the data in a GTT is not retained when the program exists.

  • You can set the number of instances to a maximum of 9999 when the Application Engine program uses only GTTs in temporary tables.

    Note: If the Application Engine program uses GTTs and temporary tables then a warning is displayed on the number of instances exceeding 99.

Note: %UPDATESTATS meta-SQL does not support Application Engine programs that use Oracle GTTs as temporary tables. On using this meta-SQL with GTT, no update statistics is generated and no updates to the system catalog tables happen.

Specifying Global Temporary Tables

You can define a GTT in Application Designer for a new or an existing record whose Record Type is selected as Temporary Table.

Image: Global Temporary Table check box

This example illustrates the Global Temporary Table (GTT) check box.

Global Temporary Table check box in Application Designer.

To define a new GTT record:

  1. Select File, New to open the New Definition dialog box in Application Designer.

  2. Select Record and click OK.

  3. Insert some fields in the Record Fields tab.

  4. Select the Record Type tab.

  5. Select the Temporary Table that displays the Global Temporary Table (GTT) check box.

  6. Select the Global Temporary Table (GTT) check box.

Likewise, if you want to set GTTs for an existing Temporary Table record, open the record in Application Designer and select the Global Temporary Table (GTT) check box.