Format string and format specifiers control the display output of the QUERY BACKUP and QUERY OBJECT commands. Any characters not contained within a format specifier are passed and displayed as is. For example, to produce Cr Time JJ BackupName, type:
%crdate% JJ %name% One exception to this rule is that the literal “\t” character sequences are translated to tab characters. To generate tab-delimited output files, type: ‘%crdate%\t%name%\t%size%’.
Override the default field width of any of these metadata files by including a colon (:) and an integer width value inside the end delimiter. Positive width values are right-justified and negative width values are left-justified.
The following table lists metadata fields, plus default widths, headings, and format specifiers.
| Field | Default Width | Heading | Format Specifier |
|---|---|---|---|
| Active/Inactive State | -1 | A/I | %status% |
| Backup name (high-level) | -30 | Backup Name | %name% |
| Compressed/Uncompressed | -1 | C/U | %compress% |
| Creation Date (YYYY-MM-DD format) | -10 | Cr Date | %crdate% |
| Creation Time (HH:MM:SS format) | -8 | Cr Time | %crtime% |
| Expiration Date (YYYY-MM-DD format) | -10 | Expire | %exp% |
| Filespace Id | 9 | FS ID | %fsi% |
| Filespace Name | -30 | FS Name | %fs% |
| Generation Number | 4 | Gen | %gen% |
| Management Class | -30 | Mclass | %mc% |
| Media Class (such as, library, fixed-disk, off-site) | -12 | Media Class | %media% |
| Number of file segments | 4 | # Seg | %segcnt% |
| Segment Name (low-level) | -30 | Seg Name | %segname% |
| Total size in MB | 9 | Size (MB) | %size% |