hi Austin,
Thank you very much for your answer:
for 1 - we are going to PostgreSQL of the VI
and union the result of the query to the PREP table so PK will be there for disposition:
(As a big picture):
create table FINAL_PREP_TABLE as
select col_PK, col1, col2,col3
from PRER_TABLE_BEFORE_FINAL
union all
select al."actionable_entity_id",null,null,null
from avi_Alert.tdc_alert_v al-- from PG
where al."actionable_entity_type_nm" = 'AAA'
about 2 and 3:
we've opened Case CS0054656 SAS Vi 10.8: send queries to external DB - if you can take a look there for more details it will be great!
We will publish the result for all here after that.
Thanks a lot,
Alex.