Excel Add-In for Informix

Build 25.0.9434

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
DBLocaleThis property specifies what Charset/Encoding will be used to parse table data.
MaxRowsSpecifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY.
OtherSpecifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details.
QueryPassthroughThis option passes the query to the Informix server as is.
ReadonlyToggles read-only access to Informix from the provider.
SessionVariablesA semicolon-separated list of SET ENVIRONMENT commands to set on the current connection.
SwitchModeThis property allows you to specify a switching mode to select a server from AlternateServers as the active server.
SwitchStrategyThis property allows you to specify a switching strategy to select a server from AlternateServers as the active server.
TimeoutA timeout for connections in seconds.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434