I'm using mod_perl and Informix, and therefore Apache:BI and DBD::Informix

It seems I am running into stale database handles

That is to say a connect in my code 'works' but any operation on the dbh
fails with a

can't call method 'blah' on an undefined value

after a time.



Reading http://search.cpan.org/~phred/Apache.../Apache/DBI.pm

suggests that I need a dbping method and an example is supplied

What 'simple' piece of sql do the team suggest?

select 1 from systables where tabid =1

for example?

TIA

--
Clive