The maximum allowed value of the JOIN_SIMPLIFICATION_THRESHOLD database option has changed to 24 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:
JOIN_SIMPLIFICATION_THRESHOLD Option in Reference: Statements and Options