Syntax:
This statement can only be performed by a SYSDBA.
The file specified after INFILE contains a series of logical individual files.
TABLELOAD <table name> is performed for each of these logical files, whereby the table name and user name are read from the file. Such a user must therefore exist in the database and be owner of a table with the same name and a suitable structure.
If a logical file cannot be loaded, a corresponding message containing the names of the table and user is output to the protocol file.
The blocks of lines that belong to rejected tables are continuously written to the file specified after OUTFILE. This file may be used as the input file for an update run after the corresponding corrections have been made to the database catalog.
No problems occur when CATALOGEXTRACT ALL and TABLEEXTRACT ALL are combined with CATALOGLOAD ALL and TABLELOAD ALL (statements DBEXTRACT and DBLOAD).