Syntax options:

    MULTISCHEMA IS ON | MULTISCHEMA IS OFF

    Specifies the multischema attribute for the database. You must
    specify the multischema attribute for your database to create
    multiple schemas and store them in catalogs. Each time you attach
    to a database created with the multischema attribute, you can
    specify whether you want multischema naming enabled or disabled
    for subsequent statements. For more information on multischema
    naming, see the User_Supplied_Names HELP topic.

    If you prefer to access a database created with the multischema
    attribute as though it were single-schema database, you can turn
    off multischema naming using the MULTISCHEMA IS OFF clause in the
    ATTACH or DECLARE ALIAS statement.

    If you have turned off the multischema attribute, you can enable
    it again using the MULTISCHEMA IS ON clause in the ATTACH or
    DECLARE ALIAS statement. You can use multischema naming only
    when you are attached to a database that was created with the
    multischema attribute. For more information, see the ATTACH
    statement.

    Multischema naming is disabled by default.