Description
Specifies whether to allocate new transaction resources each time the client application sends a request and then release those resources after each request.
Applies to
DIR SAP DirectConnect (applies only to Access Service for DB2/MVS)
Syntax
Request=value
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether you want to release transaction resources after each request. Values are:
|
Default value
Request=0
Usage
Requirements for using the Request parameter
Setting the Request parameter to 1 to release resources has an effect only when you do both of the following:
-
Set the AutoCommit database preference to True to specify that PowerBuilder should issue SQL statements outside the scope of a transaction. (See the description of AutoCommit.)
-
Specify the value for Request before connecting to a database.
What happens
When you set the Request parameter to 1, transaction resources are allocated for each request and released when the request finishes. This might slow the performance of your application, but it allows more simultaneous users of the system.
Examples
To specify that you want to release resources after each request:
-
Database profile
Select the Release Transaction Resources After Each Request check box on the Transaction page in the Database Profile Setup dialog box.
-
Application
Type the following in code:
SQLCA.DBParm="Request=1"
See also
