I can't reproduce this on 9.20.F, 9.30.UC7 or 9.40.FC1, so I'm not convinced the
problem isn't elsewhere. However, try '':INTEGER as an alternative both to NULL
and CAST.
--
Regards,
Doug Lawry
www.douglawry.webhop.org

"Michael Wimmer" <newsgroup1@ecom.at> wrote in message
news:433bb0fb$0$4084$91cee783@newsreader01.highway .telekom.at...
> 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