Specifies the default schema name for the module. The default
    schema is the schema to which SQL statements refer if those
    statements do not qualify table and other schema names with an
    authorization identifier. If you do not specify a default schema
    name for a module, the default schema name is the same as the
    authorization identifier.

    Using the SCHEMA clause, separate SQL modules can each declare
    different schemas as default schemas. This can be convenient for
    an application that needs to refer to more than one schema. By
    putting SQL statements that refer to a schema in the appropriate
    module's procedures, you can minimize tedious qualification of
    schema element names in those statements.

    When you specify SCHEMA schema-name AUTHORIZATION authorization-
    name, you specify the schema name and the schema authorization
    identifier for the module. The schema authorization identifier is
    considered the owner and creator of the schema and everything in
    it.

    When the FIPS flagger is enabled for entry-level SQL92 or lower,
    the SCHEMA clause (by itself or used with the AUTHORIZATION
    clause) is flagged as nonstandard ANSI syntax.

    If procedures in the SQL module always qualify table names with
    an authorization identifier, the SCHEMA clause has no effect on
    SQL statements in the procedures.