Re: Problems with Create VIEW ?

I strongly suspect that this is not a bug in informix, but instead a corrupted database. I'd do a series of onchecks, especially on your systables. We've done views in 7.23 (AIX), and never had that problem. Vic Andris Rigerts wrote: > A problem with views in > INFORMIX 7.22 for NT and > INFORMIX 7.23 for UNIX > > If I execute following command > CREATE VIEW xxx (column1,column2,column3) AS SELECT column1,column2,column3 > FROM table;> and then select data from it, some column names are corrupted in the result > set, for example, > column1,column2,tfvumn3 > This distortion of column names is very strange, although system tables in > a database seem to be correct. > Could anyone comment this case? -- Vic Goldberg Manager, DBA Team, Cornell University (607) 254-7441 (Voice) (607) 255-6982 (Fax)