Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list of 197 tables and I need to compare the different records.
I'm using the command
TbA:
(select col_a, col_b, col_c
from tab_1
union all
select col_a, col_b, col_c
from tab_2)
minus
(select col_a, col_b, col_c
from tab_1
intersect
select col_a, col_b, col_c
from tab_2)
TbB:
(select col_a, col_b, col_c
from tab_3
union all
select col_a, col_b, col_c
from tab_4)
minus
(select col_a, col_b, col_c
from tab_3
intersect
select col_a, col_b, col_c
from tab_4)
etc...
When recording the QVD want it saved just Tb have different records, in the amount of TBA records read is 0 QVD not save ...
Can anyone help?
if TbA and TbB etc have the same columns, QV will auto concatenate them into only one table.
Use if NoOfRows before store table
Patricia