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.

Related topic

StartUp-parameters

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[StartUp]

Abbreviation

None

Required?

No

Valid values

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

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.

 

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