Skip to Content

SCHEMA

The SCHEMA keyword overrides the default specified in the SCHEMA parameter.

The SCHEMA keyword provides the name of a schema for BMC AMI Unload to use for the SET CURRENT SCHEMA statement when CNTLCARDS DB2DDL or CNTLCARDS DB2 is specified. When SCHEMA is specified, the CREATE TABLE statement will contain an unqualified 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-Option-descriptions

SCHEMA


string

Actual SCHEMA name, with a maximum length of 128 bytes


Warning

Important

  • Blanks are allowed in the SCHEMA name.
  • 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 DDL or LOAD statements.

 

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

BMC AMI Unload for Db2 13.1