http://www.perlmonks.org?node_id=1007781


in reply to Overflow of $DBI::rows

DanEllison:

I'd try one of two things: Either tell the database to explicitly use a larger numeric datatype in the hope that the driver will handle it:

select convert(numeric(15),count(*)) from ...

or failing that, have the database convert it to a string:

select convert(varchar(32),count(*)) from ...

I've never used Teradata, so I don't know if the syntax would need tweaking, but I'd expect a trick like this to get you to your goal.

...roboticus

When your only tool is a hammer, all problems look like your thumb.