JOIN with UNION

[Tomasz Skorża <t.skorza@xxxxxxxxxxxxx>]

Hi

How to create "logical" files which will be equivalent for SQL code:

insert into LIB/FILEALL                             
SELECT * FROM FILE1 UNION ALL SELECT * FROM FILE2

With Join statement I have to use some condition, so how to union two or
more files?

I can do it by sql but I would like to have FILEALL with always "fresh"
records?

Regards

Tomasz Skorza