DB2CMTRLSE

DB2CMTRLSE

Controls the ability to maintain or release a user ID's SQL/DS connection through a COMMIT WORK

Default: DB2CMTRLSE

Valid in: configuration file, SAS invocation

CMS specifics: all

Syntax
Details

Syntax

DB2CMTRLSE | NODB2CMTRLSE

DB2CMTRLSE: issues a COMMIT RELEASE, which closes your SQL/DS connection.
NODB2CMTRLSE: issues a COMMIT WORK, which maintains your SQL/DS connection.

Details

DB2CMTRLSE enables you to maintain or release an SQL/DS connection for a given userid beyond a SAS procedure's execution. It is a convenient way to maintain connections that require SQL/DS passwords.

Chapter Contents
Previous
Next
Top of Page

Default:	DB2CMTRLSE
Valid in:	configuration file, SAS invocation
CMS specifics:	all