when we run fetch from the application program (C++) we get 18 recs, if I run an sql statement I get 200 records. From the top of your head what could be the problem.

We get no error messages. I've done reorg and runstats on all tables and indexes used in the query and it did not make any difference. db2diag did not detect any problems on the database at the time when program was run.

Thanks