ODBC buffer size

[rajaduraibanu]

hi
Can any one help me out , m facing a problem with fetchrow_array , when using in perl code .
If i specify limit in my select query with limit 100 m geting proper and expected result but for limit 200 m getting below error , i think i need to increase the ODBC buffer size but m not getting how to do .....

DBD::ODBC::st fetchrow_array failed: [unixODBC][Vertica][VerticaDSII] (20) An error occurred during query execution: (SQL-HY000)

[JimKnicely]

Hi,

What operating system is the client running on? I believe you may be looking for the ResultBufferSize parameter of the DSN? It sets the size of the memory buffer for the large result sets in streaming mode. Note: This parameter was previously called MaxMemoryCache.

[rajaduraibanu]

mmm ya thank u

[banurajadurai]

hi
m facing the same error again ,
i increased the buffer size to 5000000000, even then After fetching 2047 rows the script is getting stopped with error

DBD::ODBC::st fetchrow_array failed: [unixODBC][Vertica][VerticaDSII] (20) An error occurred during query execut ion: (SQL-HY000) at TDA_test.pl line 51.
DBD::ODBC::st fetchrow_array failed: [unixODBC][Vertica][VerticaDSII] (20) An error occurred during query execut ion: (SQL-HY000) at TDA_test line 51.


in my code there is a main select quey , inside which there are some 10 select queries ...
Here Main select query is failing