Authorized Data Truncation(-SQLTruncateToolarge)

Use this parameter 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.

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

Set this parameter to ON or ALL to perform SQL operations on truncated data. Also the data returned to the user is also truncated when its size exceeds the column size. When the parameter value is set to OFF, data will not be truncated and an error is returned.