Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 24 Mar 2008 @ 15:13:36 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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?  


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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020