Progress
Programming
Handbook


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:

You can define a temporary table to live as long as:

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


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095