Archives of the TeradataForum
Message Posted: Mon, 24 Mar 2008 @ 15:13:36 GMT
| Subj: | | Re: ODBC for Unix or JDBC with 64k SQL Limit |
| |
| From: | | Victor Sokovin |
| | Does anyone know (Victor?) if the ODBC Driver for Unix / Linux or the JDBC driver have this limit as well? | |
| | By the way: I am not so into JDBC. I only found one driver on the Teradata download centre. Is this driver for Unix / Linux and for
Windows? | |
Joerg,
1. The JDBC driver is indeed designed to work on both Windows and Unix. Unix flavors mentioned in the user guide include Solaris 8-
10, HP-UX, AIX. The driver may work with other Unix variants. Please refer to the user guide for the specific OS versions and other
requirements.
2. I don't think the problem you encountered with the 64K limit on the SQL size, with parsing disabled, is specific to the OS, so
Unix is unlikely to help but this is something to research. The 64K limit itself came as an undocumented surprise so it is hard to speculate about
it.
3. Did you have a chance to look at the conditions under which the ODBC driver can "legitimately" limit the SQL size? I included
them in my previous posting but can't recall seeing your feedback yet.
4. Try ODBC drivers by other vendors and see whether they can get the job done.
Victor
| 
