Re: Create View with a UNION ?
--Boundary_(ID_elznWb/DCQHrK/yuYsgTDQ)
Content-type: text/plain; charset=us-ascii
Content-disposition: inline
Content-transfer-encoding: 7BIT
Gail
I think the answer depends on your version of the engine. Some 2 years ago, with
version 7.1x, you could not, but with 7.3 (my current version) you can.
HTH
Sujit
Gail <wormang@sutterhealth.org> on 03/06/2000 04:34:45 PM
Please respond to Gail <wormang@sutterhealth.org>
To: informix-list@iiug.org
cc:
Subject: Create View with a UNION ?
Hello All,
Can you create a view using a UNION statement? I
--Boundary_(ID_elznWb/DCQHrK/yuYsgTDQ)
Content-type: text/plain; charset=iso-8859-1
Content-disposition: inline
Content-transfer-encoding: quoted-printable
=C6m new at writing Informix
SQL and I am receiving an error when I execute the SQL below. Any help=
will
be appreciated.
Thanks!
Gail
CREATE VIEW testgail
(activity,
fiscal_year,
period,
r_system,
atn_obj_id,
tran_amount)AS SELECT
accommitx.activity,
accommitx.fiscal_year,
accommitx.period,
accommitx.r_system,
accommitx.atn_obj_id,
accommitx.tran_amount
FROM
xxxx.accommitx accommitx
WHERE
accommitx.activity =3D '47049009'
UNION
AS SELECT
actrans.activity,
actrans.fiscal_year,
actrans.period,
actrans.r_system,
actrans.obj_id,
actrans.tran_amount
FROM
xxxx.actrans actrans
WHERE
actrans.activity =3D '47049009';
REVOKE ALL
on testgail
from public ;
Grant Select
on testgail
to public;
=
--Boundary_(ID_elznWb/DCQHrK/yuYsgTDQ)--