Micro Focus Enterprise Developer 2.3 for Visual Studio 2012 > Programming > Mainframe Programming > HCO for SQL Server (HCOSS) > Reference > SQL Compiler Directive Options - HCOSS > SQLCLRTRANS

SQLCLRTRANS

Emulates mainframe behavior by substituting SQL Server save point operations for COMMIT and ROLLBACK when building both client applications and stored procedures.

Syntax:

SQLCLRTRANS

Properties:

Default:

None

Scope:

Used at compile time:	Yes
Behavior at run time:	Source file

See Scope - HCOSS SQL Compiler Directive Options for more information.

Comments:

Uncommited work is rolled back when a stored procedure returns to the calling application unless the stored procedure was built with SPCOMMITONRETURN.

Database locks are not released until the calling application performs a COMMIT or a ROLLBACK.

If the client application is written in a language other than COBOL or PL/I, then it should also execute the SQL Server statement save transaction MF__SAVEPOINT at the start of every transaction (i.e., after every COMMIT or ROLLBACK statement) and when turning AUTOCOMMIT mode off.