Data Source Type | Maximum SQL Length Prior to 6.2 SP4 | Maximum SQL Length, 6.2 SP4 and Later |
TDV | 16000 | unchanged |
DataDirect Mainframe | 1000 | unchanged |
Greenplum | 4000 | 65536 |
Hive, Hive2 | 8000 | 32768 |
IBM DB2 | 8000 | unchanged |
IBM DB2 Type 2 | 8000 | 131072 |
IBM DB2 Mainframe | 2097152 | unchanged |
Informix | 1024 | 65536 |
JDBC | 1024 | unchanged |
Microsoft Access | 1000 | 32768 |
Microsoft Excel | 1024 | unchanged |
MySQL | 4000 | 65536 |
Netezza | 4000 (v3.0: 1024) | 65536 |
Oracle 9i | 64000 | unchanged |
Oracle 10g, 11g | 64000 | 131072 |
Oracle Type 2 | 64000 | unchanged |
PostgreSQL | 32768 | 65536 |
REST | 1024 | unchanged |
SOAP | 1024 | unchanged |
SQL Server | 8000 | 32768 |
Sybase, Sybase IQ | 4000 | 65536 |
Sybase IQ Type 2 | 4000 | unchanged |
32768 | 65536 | |
Web Services | 1024 | unchanged |
XMLFILE | 16000 | unchanged |
XMLHTTP | 1024 | unchanged |