Does anyone know whether ASE 12.5 allows one to use the union operator
in a view and if not, how to get around this limiation?

Femi Anthony

femi (AT) cnet (DOT) com (Olufemi Anthony) wrote in message news:<53ba6ff2.0312171319.301a5dcc (AT) posting (DOT) google.com>...
ASE 12.5.x does allow unions in views.

-bret

Bret Halford wrote:
There are few surprises when doing this, for example sum() + group by does
not use indexes...

Toni

Not true. I just created such a view, with a sum() in it, and it used
the index I created for it. Perhaps there is/was something in your
sql, indexes, or data that prevented using an index in your particular
case. This is not, however, the general case.

Not true. If an index is available and useable by the server, it will
use it. I just tried it and it did!

Sorry for the double post.

I have used, it works. But there was page corruption happening during
accessing the view. When contacted with sybase, they recomended to use
ESD3 or later patch which solves the problem.
-Zia