String Truncation
If an attempt is made to insert a string value into a table column that is too short to contain the value, the string is truncated.
String truncation can occur as a result of the following statements:
• COPY
• CREATE TABLE...SELECT
• INSERT
• UPDATE
To change error handling behavior for string truncation, use the -STRING_TRUNCATION=option flag on the CONNECT statement, specified when a session connects to a database.
This flag can also be specified on the command line for Vector operating system commands that accept SQL option flags.
For details about the -string_truncation flag, see the sql command description.