Table of Contents
Ispirer Website
Ispirer Capabilities - Microsoft Access Migration
Free Trial
Progress 4GL and ABL Database Access
Temporary Tables
Temporary tables are database tables that last only for the duration of the procedure that defines them or for the duration of the Progress session if you defined them as GLOBAL.
Temporary tables are private, visible only to the user that creates them.
Progress stores temporary tables in a temporary database. Temporary tables can have indexes.
Defining a Temporary Table
The DEFINE TEMP-TABLE statement is used to define a temporary table.
| Progress 4GL/ABL - DEFINE TEMP-TABLE | |
|---|---|
| Syntax | DEFINE TEMP-TABLE temp_tabname [NO-UNDO] [LIKE tabname] |
| Parameters | if NO-UNDO is specified, changes to the temporary table records remain when a transaction is undone |
Example:
DEFINE TEMP-TABLE emp-temp LIKE employees.
Temporary tables can inherit the field definitions of existing database tables, or have the fields you define explicitly.