DB2 : fetch gives different number of records

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by MarkhamDBA 0n 09 January 2009

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.

Learn more about DB2 databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting