Inbound LONG BINARY and LONG VARCHAR variables (host variables or SQL variables used by IQ) have no maximum length.
Outbound LONG BINARY and LONG VARCHAR variables (variables set by IQ) have a maximum length of 2GB - 1.
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 BIT_LENGTH, BYTE_LENGTH, BYTE_LENGTH64, BYTE_SUBSTR, BYTE_SUBSTR64, CHARINDEX, LOCATE, OCTET_LENGTH, and SUBSTRING64 functions support LONG BINARY and LONG VARCHAR variables of any size data that the SQL variable can hold. In addition, the CHAR_LENGTH, CHAR_LENGTH64, PATINDEX, SUBSTR, and SUBSTRING functions support LONG VARCHAR variables of any size data that the SQL variable can hold.
