Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 06 Aug 2008 @ 16:09:36 GMT

  <Prev Next>  
Next> Last>>  

Subj:   SQL request exceeds maximum allowed length of 1 MB
From:   Derwojed, Olaf

Hi I am Using Clementine to write to Teradata from the flat file.

     22001 [NCR][ODBC Teradata Driver] SQL request exceeds
           maximum allowed length of 1 MB

This pops up once in a while.

I am not sure what does this actually refers to ?

Does it mean:

A> that I have too many columns that I am trying to write? I.e. exceeding number of fields I am allowed to write/create in given table as assigned to me by higher powers in DBA?

B> that the total number on letters used for each column when added together exceeds 1MB and that it would make my SQL query/request exceed 1MB when compiled when I would try to access it / retrieve it?

C> something else that I did not covered in point A and B ?

I am trying to write new table with 118k rows and 22 fields/columns (from a flat file).

Kind of lost on that one :(


Olaf Derwojed

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