hi


Currently m using select TIMESTAMPADD(SQL_TSI_SECOND, $duration, '$finalOpeningDateTime') to add seconds to timestamp, but its throwing error for some datetime (i am not able to find that particular datetime value). Is there any other function to achieve this ??

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 ...

Hi

how to increase the ODBC buffer size in Vertica ?????????????????????????

hi ,


At present i av given limit as 2000 , for this oly m getting error
Can u pls give me a better idea
Even its not supporting limit 500 :(


Reply soon

Hi m getting fetchrow_array failed: error when fetching large no of rows in select query , but getting proper output when i give limit in select query to some 100 rows . my error is as below : DBD::ODBC::st fetchrow_array failed: [unixODBC][Vertica][VerticaDSII] (20) and my DBI installed versions ar...