Verify the data DB2 query

pavan_test · Post by **pavan_test** » Mon Apr 14, 2008 3:22 pm

Hi All,

How do I verify my DB2 queries where the data is loaded into mianframe.

I was able to logon to mainframe using MVFS connectivity and it does not look good at all.

Please give me suggestions.

Thanks & Regards
Mark

ray.wurlod · Post by **ray.wurlod** » Mon Apr 14, 2008 4:26 pm

I once went on a blind date and that "did not look good at all" either.

Be precise. What did you expect to see, what did you see, and why do you believe them to be different? What query is being executed? Is it a generated query or a user-defined query?

John Smith · Post by **John Smith** » Mon Apr 14, 2008 8:09 pm

Well define "looks bad". Anytime you see data in target that don't look like what you expected it most likely a job design issue. Check your column definitions carefully.