Authorized Data Truncation(-SQLTruncateToolarge)

Database Administration

Reference : Database Startup Parameters : Alphabetical listing of database startup parameters : Authorized Data Truncation(-SQLTruncateToolarge)

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

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.

OFF

When the parameter value is set to OFF, data will not be truncated and an error is returned.