HI, I have image copy of a very large table on tape.
I am using INFUTILB utility to write out few of the millions of records that I am interested in.
I am selecting as following:
Select * from Table_A where
(column_A = value_A1 and column_B = value_B1) or
(column_A = value_A2 and column_B = value_B2) or
(column_A = value_A3 and column_B = value_B3) or
(column_A = value_A100 and column_B = value_B100) ;
Values in column_A are various dates while the Column_B values are numeric.
I am writing the output to a file. The resulting records that I get have gaps. For example, it will write M number of matching records and then skip N records before writing the matching records again. If I submit the job again after changing query to only select the records it missed the first time, it finds some but still misses a lot of them.
why would this be the case?