LOAD supports the loading and extracting of data sets and catalog contents. In addition, it is an important instrument for installing ADABAS and can be sensibly employed for the distribution of SQL applications.
- Loading tables from external files (DATALOAD)
- Update loading individual table columns (DATAUPDATE)
- Providing database extracts in
external files for further processing (DATAEXTRACT)
- Migration of databases and tables (TABLEEXTRACT)
to other computers (TABLELOAD)
- Migration of the database catalog (CATALOGEXTRACT)
to other computers (CATALOGLOAD)
- Execution of batch files with
SQL and LOAD statements and
data flow control (command file)
LOAD processes its own statements and SQL statements. These statements can be recorded as a command sequence in a command file and executed in batch mode. Flow control statements and reactions to return codes are possible in a command file.
LOAD can also be operated interactively. Statements and test data can be input via an editor. Syntax errors are displayed and can be corrected immediately. Command files can be developed and tested statement by statement.
The consistency of the database defined in the schema is ensured also during LOAD runs: Rows which would impair this consistency are rejected, collected in a protocol file, and provided with error comments. Apart from a row-wise loading (DATALOAD), a page-oriented loading (FASTLOAD) is also supported which runs with a considerably enhanced performance. Here, too, the defined integrity conditions are checked.
LOAD provides a high level of support when converting input values from the external data format into the data type which was determined in the table definition. Various external data formats can also be selected when making the data available.
During the LOAD runs, the tables involved remain available for multi-user operations. The transaction behavior of LOAD can be set.
The integration of ADABAS into the existing IT environment of a company and the automation of administrative measures when operating database applications are made considerably easier with LOAD. For example, LOAD supports the import of ORACLE databases on the basis of the EXPORT format of ORACLE.