Text Size

If the gateway or DBMS has support for limiting the length of the data returned from a LONG VARCHAR or LONG VARBINARY column, the IDS_AUX_SETTEXTSIZE string contains the SQL statement sent to the gateway with the size appended. If the IDS_AUX_SETTEXTSIZE string is empty, the SQLSetStmtOption SQL_MAX_LENGTH option returns SQL_ERROR with a SQL State of S1C00. If there is a non-infinite default that limits the size of long columns, be sure to include the proper initialization string to set no limit in the gateway. For more information, see Gateway Initialization.