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 Post
Re: How can I find garbage data using a SQL statement?2012-10-05T22:59:40ZThis is the accepted answer. This is the accepted answer.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.