STRING_TRUNCATION
SET STRING_TRUNCATION IGNORE|FAIL|WARN statement changes the current
error handling setting (see
Specify Error Handling for String Truncation on page 102) for string truncation.
The default setting is WARN, which truncates and inserts the string and issues a warning. For example, it notifies you when truncation occurs when unloading or reloading a database using unloaddb or copydb. This can be especially useful if you are migrating to UTF8 using the -nvarchar flag.
Valid values are:
IGNORE
Truncates and inserts the string without issuing a message.
WARN
(Default) Truncates and inserts the string and issues a warning.
Note: X100 operations treat WARN as FAIL.
FAIL
Aborts the statement and issues an error. In X100, the FAIL option is supported only for singleton INSERTs and COPY. It is supported only in cases where the literal string value can be validated, so it is not supported for CREATE TABLE AS SELECT, INSERT...SELECT, nor for updates where the string value originates from an expression from another table.
Last modified date: 04/26/2024