The case sensitivity setting of your SAP Sybase IQ database should match the settings used by any remote servers accessed.
SAP Sybase IQ databases are created case insensitive by default. With this configuration, unpredictable results may occur when selecting from a case-sensitive database. Different results will occur depending on whether ORDER BY or string comparisons are pushed off to a remote server, or evaluated by the local SAP Sybase IQ server.