Configuration Command
Set the input statement terminator to a character.
terminator [CHAR]
CHAR
Any single character (including ASCII control characters) or one of the following:
\t |
tab |
\n |
newline (default) |
\\ |
backslash |
If you omit CHAR, the terminator is set to the default (\n).
Description
This command does not apply to the DB/2 environment, where the command terminator is fixed as "\n". If you want insert or update a field with embedded newlines, you must first replace them with a placeholder. When that field is subsequently selected from the database, the placeholder can be replaced with newlines.
The SQL application does not attempt to execute a command until an entire statement has been sent. By default, an entire statement is defined as newline terminated. This command allows the application to change the character that signifies end of line. This is useful when a SQL command must contain data with embedded newlines.
Note that, when using the ORACLE interface, this command operates properly only when the SQL executable is run from an ESL application.
Example
response to start
start local SQL "eslsqlo9"
send "terminator |\n" to SQL
send "insert into sample values (\"line1\nline2\n\")|" to SQL
