Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Progress 4GL to .NET Conversion Request SQLWays

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.


Ispirer Home Page Ispirer SQLWays Product Page - Progress 4GL to .NET Conversion Request SQLWays

sqlways/progress-4gl/database-access.txt · Last modified: May 07, 2018, 03:15:32 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement