Default language.

Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Unload for Db2 13.1.

+SCHEMA

(SPE2104)

The +SCHEMA parameter provides the name of a schema for BMC AMI Unload to use for the SET CURRENT SCHEMA statement in LOAD control cards when CNTLCARDS DB2DDL or CNTLCARDS DB2 is specified. When +SCHEMA is specified, the CREATE TABLE statement no longer provides the creator information, but only the table name.

For CNTLCARDS DB2, the SCHEMA name is provided as a qualifier for the table name in the LOAD statement.

SCHEMA.png

string

Actual SCHEMA name, with a maximum length of 128 bytes.

The default is +SCHEMA() (no value).

The UNLOAD command option SCHEMA overrides this parameter.

Important

  • Blanks in the +SCHEMA parameter are removed as per the Parameter syntax rules. For SCHEMA name with blanks, use the SCHEMA keyword.
  • No validation is performed at the time that you specify the SCHEMA name.
  • If you misspell a SCHEMA name, it results in an error that might affect the execution of subsequent SQL statements.

Related topics

BMC-AMI-Unload-parameters-ULDPARMS-DD

SCHEMA

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*