where:
- CATALOG or CTLG
- Enables CATALOG at the table level for ARCHIVE, RESTORE/COPY and/or ANALYZE statements
- CATALOGALLTABLES or CTLGALL
- Synonyms for CATALOG
- CATALOGOBJONLY or CTLGOBJ
- Enables CATALOG at the object level for ARCHIVE, RESTORE/COPY and/or ANALYZE statements
- CATALOGFILE or CTLGFILE
- Enables CATALOG to write all catalog information to a file on the client machine.
- OLDCATALOG or OLDCTLG
- When specified, along with CATALOG, enables use of the multi-table implementation of CATALOG, instead of the single-table method which does not create a new table for each ARCHIVE.
- NOCATALOG or NOCTLG
- Disables CATALOG for ARCHIVE, RESTORE/COPY and/or ANALYZE statements.
- CATALOGFILENAME or CTLGFILE
- Enables changing the file name for the catalog.
- NOCATALOGFILE or NOCTLGFILE
- Disables CATALOGFILE so that catalog information is not created during ARCHIVE, and not used during RESTORE or COPY.
The following syntax is not supported:
- CATALOGALL
- CTLGALLTABLES
- CATALOGOBJ
- CTLGOBJONLY