Progress
Programming
Handbook
Similarities Between Temporary and Work Tables
Temporary tables and work tables have the following similarities:
- You create temporary tables and work tables with a DEFINE statement, and they are scoped to the procedures that define them. When you specify the LIKE table option, both inherit the attributes of the specified database table (table). This optionally includes all Data Dictionary validation for the table (using the VALIDATE option). However, temporary tables and work tables do not inherit schema triggers from the database table.
- The NEW SHARED and SHARED options allow two or more procedures to access the same temporary tables and work tables.
- Update statements, such as UPDATE, CREATE, and DELETE, that reference a temporary table or a work table do not require a transaction to be active. If you want a temporary table or a work table to participate in a transaction, you must explicitly start a transaction for it.
- The UNDO and NO–UNDO options allow you to decide whether to incur the overhead associated with transaction and nested UNDO processing.
- Whenever a Progress session ends due to a crash or a QUIT statement, Progress deletes all records in temporary tables (and the temporary database itself) and all records in work tables.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |