NOTICE: 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.
This topic has been locked.
1 reply Latest Post - 2012-10-05T22:59:40Z by JohnAndersen
Pinned topic How can I find garbage data using a SQL statement?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
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 270005R1KN1 PostACCEPTED ANSWER
Re: How can I find garbage data using a SQL statement?2012-10-05T22:59:40Z in response to PWConnerIf 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.