Reason:
You executed a query containing a HAVING clause against a view containing a HAVING.
The SQLSTATE that equates to this SQL return code is 0AS01.
Action:
Remove the HAVING from the query (add a predicate to the WHERE clause that accomplishes the elimination of the groups that the HAVING was intended to eliminate) or change the query to reference the base table or view on which the offending view is defined. The offending view may be a view that is directly or indirectly referenced by the view that the query referenced.
|
Copyright © 2014 CA.
All rights reserved.
|
|