Batch Processing & Reporting › The Archive/Restore Program (CAKSARCH) › The BACKUP Option

The BACKUP Option

Archiving/Backup of CA PMA Chargeback tables is performed using the BACKUP option of the CAKSARCH program described below.

BACKUP TBL=tableid,DD=ddname[,where_clause;]

where:

TBL=

The name of the table to be backed up. For example, CAI.PERTAB, or PMA.QUALTAB. All versions stored in each table are backed up.

DD=

References the JCL ddname that is used. This must be unique for each table BACKUP statement. A corresponding DD statement must also be defined.

where_clause (optional)

It is recommended that you always backup an entire table, which means you would not use a WHERE clause. However, if used, the WHERE clause must end with a semicolon (;). WHERE clauses can be continued using spaces and commas.

• If a where_clause is used, CA PMA Chargeback backs up the records that meet the where_clause's selection criteria.
• If a where_clause is omitted, CA PMA Chargeback backs up all records stored in the specified table.