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 |
|
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