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.

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


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.

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.