MAX_JOIN_ENUMERATION Option

The maximum allowed value of the MAX_JOIN_ENUMERATION database option has changed to 32 in SAP Sybase IQ release 16.0 SP2.

In previous releases, the maximum allowed value was 64.

See this topic in the SAP Sybase IQ 16.0 SP2 documentation:

MAX_JOIN_ENUMERATION Option in Reference: Statements and Options

Related concepts
Read This First: Helpful Hints Before You Start Using SAP Sybase IQ 16