DataManager Batch Processing and Reporting › The Archive/Restore Program (CAKSARCH) › The RESTORE Option › RESTORE Output

RESTORE Output

When DataManager successfully backs up your table, you'll receive printed output like this:

COMPANY NAME               ARCHIVE/RESTORE PROGRAM                     PAGE   1
CA PMA/DM 1.0 9010KS100             REPORT             Thu Nov 08 13:26:47 1990
                USING: DATABASE=DSNDB04, SUBSYS=DB23, WHATSQL=DB2
 
INPUT:
RESTORE TBL=CAI.RESTIRD,DD=BACKTAB
 
FILE HEADER LINE=** TABLE=CAI.IRDDESC  COLS=9  on 10/4/1990  11:11:51 AM
 
SQL:
    CREATE TABLE  CAI.RESTIRD
VERSION CHAR(4),
    DATASET CHAR(7),
    IRDID CHAR(8),
    DESCRIPT CHAR(20),
    ORIGIN CHAR(1),
    IDBEGPOS CHAR(5),
    IDLENGTH CHAR(2),
    IDHEXVAL CHAR(20),
    LENGTH CHAR(5)) IN DATABASE DSNDB04
 
CAKS632I - TOTAL NUMBER OF ROWS PROCESSED=30
CAKS611I - RESTORE PROCESSING COMPLETED SUCCESSFULLY

INPUT:

Displays the RESTORE control statement processed during this run.

SQL:

Displays the SQL statement DataManager submits to the database to restore this table.

CAKS messages

Tell what happens while this job is processing.