Syntax options:

    DICTIONARY IS REQUIRED | DICTIONARY IS NOT REQUIRED

    Specifies whether or not definition statements issued for the
    database must also be stored in the repository. If you specify
    the REQUIRED option, any data definition statements issued after
    an ATTACH or DECLARE ALIAS statement that does not specify the
    PATHNAME argument fails.

    If you specify the DICTIONARY argument in an ALTER DATABASE
    statement, you cannot specify any other database root file or
    storage area parameters.

    If you omitted the PATHNAME clause from the database root file
    parameters in the CREATE DATABASE statement that created the
    database, SQL generates an error if you specify DICTIONARY IS
    REQUIRED in an ALTER DATABASE statement for the same database.
    This is not true if you use the INTEGRATE statement with the
    CREATE PATHNAME clause to copy database definitions to the
    repository before specifying the DICTIONARY IS REQUIRED clause
    in an ALTER DATABASE statement for that database.