IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2012-10-05T22:59:40Z by JohnAndersen
42 Posts

Pinned topic How can I find garbage data using a SQL statement?

‏2012-06-05T15:03:09Z |
We have a table, t1, in two libraries, lib1 and lib2. t1 does not have the same number of fields in both libraries. lib1/t1 has about 6 less fields at the end of the record format than lib2/t1. Level check is turned off on both tables. A RPG program ran over lib2/t1 that was meant for lib1/t1 and truncated some of the records. Using SQL how can I find the records?
Updated on 2012-10-05T22:59:40Z at 2012-10-05T22:59:40Z by JohnAndersen
  • JohnAndersen
    1 Post

    Re: How can I find garbage data using a SQL statement?

    ‏2012-10-05T22:59:40Z  in response to PWConner
    If the data more or less matches between the two files using a left join... there is probably a better way but, off the top of my head, that should get you there.

    -John Andersen