3. Elements of SQL Statements : SQL Operations : Assignment Operations : String Truncation
 
Share this page                  
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.