Is there a generic way using DBI to limit the number of rows returned by a query regardless of the DB you are connecting to? I am debugging a program that is fairly long and has several places where large RS are returned. I really don't feel like adding LIMIT syntax to each query(especially because in some places the SQL is dynamic), I'd rather just be able to do something to the excute where it just gives me back say 100 rows rather than the whole thing. My other problem is that this particular script connects to various DB types so the syntax for the SQL is different even if I chose to add a LIMIT clause to each query.
Thanks