ADABAS permits the user to define temporary tables which exist up to the end of the session. Temporary tables are implicitly deleted at the end of a database session.
Example:
CREATE TABLE TEMP.delivery
(seq_no FIXED(5),
customer CHAR(20),
product CHAR(20),
address CHAR(30),
PRIMARY KEY(seq_no)) IGNORE ROLLBACK
Temporary tables are particularly suitable as auxiliary tables which are only required for the duration of an application execution. These tables have no overhead for catalog administration because they are user-specific. They can be operated optionally with or without logging (IGNORE ROLLBACK).
Especially in DB procedures, temporary tables can be used to create large intermediate results which can be accessed via SELECT and FETCH.