Save qvd

[#1]

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?

[giakoum]

if TbA and TbB etc have the same columns, QV will auto concatenate them into only one table.

[#3 · Accepted solution]

Use if NoOfRows before store table

Patricia