Adaptive Server IQ 12.4.0 | Large IN subqueries |
• | = ALL |
• | != ALL |
If you use an unsupported query in this group, Adaptive Server IQ returns an error like the following:
Feature, ANY, not yet implemented
Queries of this type can always be expressed in terms of IN subqueries or scalar subqueries using MIN and MAX set functions.
7.2.2 Large IN subqueries
There is a known performance limitation in Adaptive Server IQ version 12 that affects IN subqueries that return more than 1 million distinct values; such queries should be rewritten in term of correlated EXISTS subqueries until this server limitation is addressed.
7.3 Adaptive Server IQ Operations
This section reports problems with Adaptive Server IQ operations.
7.3.1 Output to file in DBISQL
There are known problems in using the output to file feature from a DBISQL session that will cause a server to abort. Do not use this feature in this release. Instead, put > filename on the end of a select statement.
The cases that cause the abort are:
•Using the feature when the IQ option Force_No_Scroll_Cursors is set to
ON
•Performing a rollback command following the output to command, as in
select * from ....;
output to file; rollback;
7.3.2 Changing length of DBISQL column values
By default, the maximum length of column values displayed by DBISQL is 30 characters. This may be inadequate for displaying output of stored procedures such as sp_iqstatus.
Release Bulletin for Digital UNIX | 11 |