TEXT_TABLE_MAX_WIDTH

This option defines the maximum length of a TextTable row in bytes.

The default value is set to 1048576 (1 MB).

To get the current value of this option, you can use this statement:

SQL

SELECT * FROM (CALL "SYSADMIN.getDefaultOptionValue"('TEXT_TABLE_MAX_WIDTH')) AS a;;

1. Setting the maximum size to 10 KB:

SQL

CALL "SYSADMIN.setDefaultOptionValue"('TEXT_TABLE_MAX_WIDTH', 10240);;

2. Resetting the maximum size to the default value (1 MB):

SQL

CALL "SYSADMIN.setDefaultOptionValue"('TEXT_TABLE_MAX_WIDTH', '');;