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 High-speed Apply Engine 13.1.

SQLTerminator


The SQLTerminator parameter specifies the character that ends each SQL statement in the input file. This parameter allows you to set the SQL terminator character to something other than a semicolon (;), which is the default.

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[StartUp]

Abbreviation

None

DBMS

Db2, Db2 LUW, Oracle

Required?

No

Valid values

  • Db2

    Any character except space, comma, single quote ('), double quote ('), left parenthesis, right parenthesis, or underscore (_)

  • Db2 LUW

    Any character except space, left parenthesis, or right parenthesis

  • Oracle

    Any character except space, single quote ('), or double quote (')

Default value

semicolon (;)

Usage

If your SQL statements terminate with a character other than a semicolon, use the SQLTerminator parameter to specify that character. The High-speed Apply Engine also uses the current terminator (from the configuration or from the SQL file) for any statements written to the conflict file.

You can also designate a terminator character in your input SQL. For more information, consult the DBMS documentation.

Related topic

 

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