Specifies whether to allocate new transaction resources each time the client application sends a request and then release those resources after each request.
DIR Sybase DirectConnect (applies only to Access Service for DB2/MVS)
Request=value
Parameter |
Description |
|---|---|
value |
Specifies whether you want to release transaction resources after each request. Values are:
|
Request=0
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.
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"
