Sybase IQ 15.2 includes several enhancements for loading and working with large object data.
You can load large object data of unlimited size, unless restricted by the operating system, from a primary load file in ASCII or BCP format. Large object data includes the LONG BINARY and LONG VARCHAR data types.
The LOAD TABLE, INSERT…VALUES, INSERT…SELECT, INSERT…LOCATION, SELECT…INTO, and UPDATE SQL statements accept LONG BINARY and LONG VARCHAR variables of any size of data. Currently, a SQL variable can hold up to 2GB - 1 in length.
The LIKE predicate supports LONG VARCHAR variables of any size.
Most of the functions that support the LONG BINARY and LONG VARCHAR data types also support LONG BINARY and LONG VARCHAR variables of any size. See Unstructured Data Analytics in Sybase IQ > Function Support.
The TEXT index supports LONG BINARY and LONG VARCHAR columns.
Users must be specifically licensed to use the large object data types LONG BINARY and LONG VARCHAR. For details on the large object management enhancements and the Unstructured Data Analytics Option, see Unstructured Data Analytics in Sybase IQ.
