+SCHEMA

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

Related topics

BMC-AMI-Unload-parameters-ULDPARMS-DD

SCHEMA


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.

 

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