Page 1 of 1

Verify the data DB2 query

Posted: Mon Apr 14, 2008 3:22 pm
by pavan_test
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

Posted: Mon Apr 14, 2008 4:26 pm
by ray.wurlod
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?

Posted: Mon Apr 14, 2008 8:09 pm
by John Smith
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.