Tailoring Temporary Table Visibility and Life Span
Depending on how you specify the NEW, GLOBAL, and SHARED options of the DEFINE TEMP–TABLE statement, you can tailor the visibility and life span of the temporary table to the needs of your application.
You can define a temporary table that is visible to:
- Only the procedure that creates it
- The procedure that creates it, and the procedures that the creating procedure calls
- All procedures in the Progress session
You can define a temporary table to live as long as:
- The procedure that creates it
- The current Progress session
Table 15–2 displays the DEFINE TEMP–TABLE options you should specify for each type of temporary table, and the resulting temporary table’s visibility and life span.
Table 15–2: Temporary Table Options, Visibility, and Life Span
Type
|
Options
|
Visibility
|
Life Span
|
Not Shared and Not Global
|
DEFINE...
|
The creating procedure
|
The creating procedure
|
Shared
|
DEFINE NEW SHARED... (in the creating procedure)
DEFINE SHARED... (in the procedures that the creating procedure calls that want to share the temporary table)
|
The creating procedure, and the procedures that the creating procedure calls that want to share the temporary table
|
The creating procedure
|
Global
|
DEFINE NEW GLOBAL... (in the creating procedure, and in other procedures in the Progress session that want to access the temporary table)
|
All procedures in the Progress session
|
The Progress session
|