Hi,

I tried to do a select NULL as... for an not existing column in an Union
select statement.

I have a problem with my solution in 9.3 when I try to turn the select
into a view and work with the view.

Select and create view work (below is a simplified version)

select cast(null as integer) nilcol from informix.systables
-> works


create view niltab(nilcol) as
select cast(null as integer) nilcol from informix.systables
-> works


But the select fails:

select * from niltab
201: A syntax error has occurred.

It works in 9.4 but I would need it in 9.3. Can anybody give me an hint
or workaround how I can make this work in 9.3?

Regards,

Michael