View Single Post
  #9 (permalink)  
Old 11-23-09, 09:45
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,448
According to the manual (http://publib.boulder.ibm.com/infoce...ubselect.htm):
Quote:
If [...] table-reference identifies a distributed table, a table that has a read trigger, a DDS-created logical file, or logical file built over multiple physical file members; the query cannot contain:

* EXCEPT or INTERSECT operations,
* OLAP specifications,
* recursive common table expressions,
* ORDER OF, or
* scalar fullselects (scalar subselects are supported).
Reply With Quote