Use the Authorized Data Truncation (-SQLTruncateTooLarge) parameter to truncate the data returned to the user when its size exceeds the column size.

Operating system and syntax UNIX / Windows 
-SQLTruncateTooLarge { ON|ALL|OFF|OUTPUT}
Use with Maximum value Minimum value Single-user default Multi-user default
CC, DBS — — OFF OFF
OUTPUT
Set this parameter to OUTPUT to truncate the data returned to the user when its size exceeds the column size. All SQL operations such as comparison, sorting use actual data and only the output is truncated.
ON/ALL
-SQLTruncateTooLarge no longer supports the ON or ALL options and treats them as OUTPUT. For more information, see the description of OUTPUT. The database log (.lg) file records this information and displays the following message:
(17955) Authorized data truncation (-SQLTruncateTooLarge): OUTPUT (ALL and ON are not supported and will be treated as OUTPUT)
OFF
When the parameter value is set to OFF, data will not be truncated and an error is returned.

The Authorized Data Truncation (-SQLTruncateTooLarge) parameter may be modified while your database is online using PROMON or through the _DbParams VST. This change will only take effect on the primary broker and its newly spawned servers.