Specifies how EAServer should behave when it releases control of a connection. This parameter applies only when a PowerBuilder custom class user object is deployed as an EAServer component.
JDB JDBC
ODBC
O84 Oracle 8.x and Oracle8i
O90 Oracle9i
O10 Oracle 10g
SYJ Sybase Adaptive Server Enterprise
ReleaseConnectionOption = 'value'
ReleaseConnectionOption = 'JAG_CM_UNUSED'
Use JAG_CM_DROP to destroy a connection when errors have made it unusable. This parameter cannot be set dynamically. The value set when the connection is made remains in effect until it is disconnected.
Using the SYJ interface
Sybase EAServer uses a slightly different version of the CT-Lib
software. Therefore, at runtime, you need to
use the SYJ database interface rather than SYC to connect to an
Adaptive Server Enterprise database. The SYJ Database Profile Setup
dialog box provides a convenient way to set the appropriate connection
parameters and then copy the syntax from the Preview tab into the script
for your Transaction object.
You cannot use the SYJ interface, however, to connect to the database in the PowerBuilder development environment. Therefore, during the development phase (before the component has been deployed to EAServer), you must use SYC to connect to the database.
For information on how to use PowerBuilder to build EAServer components, see Application Techniques.
On the EAServer tab in the Database Profile Setup dialog box, select JAG_CM_DROP from the Release Connection Option drop-down list. The PowerScript syntax for the ReleaseConnectionOption parameter displays on the Preview tab:
SQLCA.DBParm = "ReleaseConnectionOption = 'JAG_CM_DROP'"
Copy the syntax from the Preview tab into your script.
