In this section: |
The Adapter for Progress provides several parameters for customizing the environment and optimizing performance. This topic provides an overview of customization options.
How to: |
The Adapter for Progress 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.
ENGINE SQLPRO SET NONBLOCK {0|n}
where:
Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
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:
Note: A value of 1 or 2 should be sufficient for normal operations.
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.
ENGINE SQLPRO SET PASSRECS {ON|OFF}
where:
Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
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.
Provides no information after the successful execution of an SQL Passthru INSERT, UPDATE, or DELETE command.
How to: |
TIMEOUT specifies the number of seconds the adapter will wait for a response after you issue an SQL request to Progress.
ENGINE SQLPRO SET TIMEOUT {nn|0}
where:
Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
Is the number of seconds before a time-out occurs. 30 is the default value.
Represents an infinite period to wait for a response.
How to: |
You can specify the transaction isolation level from the Web Console or using the SET ISOLATION command.
You can specify transaction isolation level by issuing the following command
ENGINE SQLPRO SET ISOLATION {RU|RC|RR|SE}
where:
Sets the transaction isolation level to Read Uncommitted.
Sets the transaction isolation level to Read Committed.
Sets the transaction isolation level to Repeatable Read.
Sets the transaction isolation level to Serializable Read.
WebFOCUS |