I'm attempting to build a query using views.
On the fourth view I get an error which isn't documented in the
manual v7.1 "Informix Error Messages"  I couldn't find this one in
the IIUG usenet archive either.

create view t_pctoffund

        (fcode, pcode, ishares, nshares, monthend, fshares, pct) as

select          t_ph.fundcode,
        t_ph.partnercode,
        t_ph.initshares,
        t_ph.newshares,  
                t_mh.monthend,
        t_mh.fundshares,                                    
                (t_ph.initshares + t_ph.newshares) /
                t_mh.fundshares pct          
|                                                                          
|      Owner name "initshares" has exceeded 8 characters in length.        
| See error number -4624.                                                  
...

thanks,
nelson
Nelson Fredsell
Cornerstone Capital
Atlanta, GA

I worked around this, thanks.
-Nelson

Nelson Fredsell
Cornerstone Capital
Atlanta, GA