Using TIB_DSQL for a SELECT statement is perfectly acceptable as long as you
actually want an error/exception if anything other than a single record only
is returned. This means if the select has ZERO or more than ONE records you
get an error. This is desirable and efficient if its what you want. You
either succeed with the record of interest or get an exception without
having to check this or that attempting to fetch in more records, etc.

Jason Wharton