Customizing the Informix Environment

In this section:

The Adapter for Informix provides several parameters for customizing the environment and optimizing performance.


Top of page

x
Obtaining the Number of Rows Updated or Deleted

How to:

PASSRECS returns the number of rows affected by a successfully executed SQL Passthru INSERT, UPDATE, or DELETE command.

Tip: You can change this setting manually or from the Web Console by clicking Data Adapters on the menu bar, clicking a configured adapter, and choosing Change Settings from the menu. The Change Settings pane opens.



x
Syntax: How to Obtain the Number of Rows Updated or Deleted
ENGINE SQLINF SET PASSRECS {ON|OFF}

where:

SQLINF

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

ON

Provides the number of rows affected in the application program SCB count member after the successful execution of an SQL Passthru INSERT, UPDATE, or DELETE command. ON is the default value.

OFF

Provides no information after the successful execution of an SQL Passthru INSERT, UPDATE, or DELETE command.


Top of page

x
Activating NONBLOCK Mode

How to:

The Adapter for Informix has the ability to issue calls in NONBLOCK mode. The default behavior is BLOCK mode.

This feature allows the adapter to react to a client request to cancel a query while the adapter is waiting on engine processing. This wait state usually occurs during SQL parsing, before the first row of an answer set is ready for delivery to the adapter or while waiting for access to an object that has been locked by another application.

Tip: You can change this setting manually or from the Web Console by clicking Data Adapters on the menu bar, clicking a configured adapter, and choosing Change Settings from the menu. The Change Settings pane opens.



x
Syntax: How to Activate NONBLOCK Mode
ENGINE SQLINF SET NONBLOCK {0|n}

where:

SQLINF

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

n

Is a positive numeric number. 0 is the default value, which means that the adapter will operate in BLOCK mode. A value of 1 or greater activates the NONBLOCK calling and specifies the time, in seconds, that the adapter will wait between each time it checks to see if the:

  • Query has been executed.
  • Client application has requested the cancellation of a query.
  • Kill Session button on the Web Console is pressed.

Note: A value of 1 or 2 should be sufficient for normal operations.


Top of page

x
Using a Quoted Identifier

How to:

The QUOTED_IDENTIFIER setting enables the adapter for Informix to set the Informix environment variable DELIMIDENT, which determines whether the database server interprets strings enclosed in double quotation marks as SQL identifiers or as literal strings.

When the DELIMIDENT environment variable is set to ON, the adapter generates SQL with double quotation marks around identifiers such as table names and column names, when necessary. (For details about the effects of setting the DELIMIDENT environment variable, refer to the Informix documentation.)

The DELIMIDENT environment variable is passed to the Informix database by the Informix client at the moment the client connects to the database; the variable remains in effect until the Informix client disconnects from the database. The adapter connects to the Informix database when the adapter starts executing a command that references objects residing in that database. By default, the adapter does not disconnect until the end of the server agent session. Setting DELIMIDENT does not affect current connections to the database unless you force the adapter to reconnect. You can force it to reconnect by issuing the following commands:

SQL SQLINF SET AUTODISCONNECT ON COMMAND
SQL SQLINF END SESSION   

Tip: You can change this setting manually, or change it from the Web Console by clicking Data Adapters in the menu bar, clicking the name of a configured adapter, and choosing Change Settings from the menu.

Note: The DELIMIDENT variable is supported by the Dynamic, XPS, and SE Informix Servers. However, it is not supported by Informix Online.



x
Syntax: How to Enable Quoted Identifiers Around Strings
ENGINE SQLINF SET QUOTED_IDENTIFIER {OFF|ON}

where:

SQLINF

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

OFF

Indicates that strings enclosed in double quotation marks are to be interpreted as literal strings. OFF is the default value.

ON

Indicates that strings enclosed in double quotation marks are to be interpreted as SQL identifiers.


WebFOCUS