Create view over multiple files

Still learning about SQL.

I want to create a view over the union of two files.

I have worked out the SQL syntax to create a file, but
this does not update when the base files change.

I think this means I want to create a view instead of a file,
but nothing seems to work. Given the SQL below to create
a file with data, how do I modify it to create a view instead?

Thanks,
Lance

create table htedta/GMCVWD01 as (
with
tempfile as (
SELECT
GMTDY as gmyy,
gmtdm as gmmm,
gmtdd as gmdd,
GMFUND as FUND,
GMDPT as DEPT,
GMDIV as DIVISION,
GMSTAB as ACTIVITY,
GMSTAS as subactiv,
GMELM1 as ELEMENT1,
GMELM2 as ELEMENT2,
GMOBJ as OBJECT,
GMPROJ as proj,
GMAPYR as acctyr,
GMAPMO as acctmo,
GMTDSC as desc,
(GMdAMT - GMcAMT) as transamt,
'AJ' AS FLAG
FROM htedta/gm310ap WHERE gmproj <> ' '
UNION ALL
SELECT
GMTDY as gmyy,
gmtdm as gmmm,
gmtdd as gmdd,
GMFUND as FUND,
GMDPT as DEPT,
GMDIV as DIVISION,
GMSTAB as ACTIVITY,
GMSTAS as subactiv,
GMELM1 as ELEMENT1,
GMELM2 as ELEMENT2,
GMOBJ as OBJECT,
GMPROJ as proj,
GMAPYR as acctyr,
GMAPMO as acctmo,
GMTDSC as desc,
GMAMT as transamt,
'AP' AS FLAG
FROM htedta/gm310gp WHERE gmproj <> ' ')
SELECT gmyy, gmmm, gmdd, fund, dept, division, activity, subactiv,
element1, element2, object, proj, acctyr, acctmo, desc,
transamt, flag
from tempfile) with data