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:

  PowerBuilder

  SQLCA.DbParameter="Request=1"

  1	SQLCA.DbParameter="Request=1"