We have one db2 query to get number of records from one table with data
range criteria. Query is like this

Select count(*) from CCUSER.T_AUDIT_TRAIL a Where a.CASE_DESC IN ( Select
b.CASE_DESC FROM CCUSER.T_CASE_REFERENCE_MASTER b ) AND a.END_DATE
BETWEEN
'2004-08-01 00:00:00' AND '2004-08-31 23:59:59'

What we observed is when we fire this query on DB2 command prompt and when
we fire this through VB application, results are coming different. Record
Count does not match.

Any suggestions??

Thanks in advance.

Regards,
Rekha
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you



DB2 & UDB email list listserv db2-l LazyDBA home page