Unload to fname (concatenating the sql's) 1

[ejaggers]

Is there a way to concatenate multiple SQL's into one file?
i.e.:

unload to fname select * from table1;
unload to fname select * from table2;
unload to fname select * from table3;

 

[PHV]

unload to fname select * from table1 union all select * from table2 union all select * from table3;

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886