hello, I'm new in ruby, I've problems conneting ruby odbc with informix 
db, in tbles with thousand records my program always retruns no rows,

this is the test program:

sth=c.prepare("select * from anopta")

sth.execute
if sth.ncols == 0 then
     puts "Statement has no result set"
     printf "Number of rows affected: %d\n", sth.nrows
   else
     puts "Statement has a result set"
     sth.fetch_all
     printf "Number of rows: %d\n", sth.nrows
     printf "Number of columns: %d\n", sth.ncols
  end


this is the output

Statement has a result set
Number of rows: -1
Number of columns: 5

The table has 5 colums and 300 rows

I don't know if this problem is specific for informix databases

thank u very much