VMS Help  —  SQL72  Information Tables, RDB$JOURNALS
    Displays information about the database journal files.

    Column Name                 Data Type      Description

    RDB$LAST_BACKUP             date vms       Date of last AIJ
                                               backup
    RDB$STATUS                  integer        AIJ file is
                                               inaccessible
    RDB$ALLOCATION              integer        Allocation
    RDB$EXTENT                  integer        Extent
    RDB$FLAGS                   integer        Flags
    RDB$JOURNAL_NAME            char(31)       Journal name
    RDB$LAST_BACKUP_SEQUENCE    integer        Last version number
                                               backed up
    RDB$LAST_ACTIVATED          date vms       Date last activated
    RDB$BACKUP_EDIT_STRING      varchar(255)   Backup editname file
    RDB$DEFAULT_FILENAME        char(255)      Default journal name
    RDB$FILENAME                char(255)      Journal name
    RDB$BACKUP_FILENAME         char(255)      Backup file name
    RDB$SEQUENCE_NUMBER         integer        Current AIJ sequence
                                               number
    RDB$STATE                   char(31)       State ("Current" or
                                               "Latent")
Additional Information: explode extract
RDB$FLAGS
Close Help