OPTION (deprecated)

Parameters:

NORSLOCATORS

Enables non-COBOL client applications to read result sets from COBOL stored procedures that have been migrated from the mainframe. SQL Server COBOL stored procedures return result sets as simulated mainframe result sets. NORSLOCATORS applies only when both DIALECT=MAINFRAME and DBMAN=ADO are also set.

CHECKCALLPARAMS

Evaluates the parameters on a stored procedure call to determine if they are input or output. Automatically set by DIALECT=MAINFRAME.

SQLCLRTRANS

Emulates mainframe behavior by substituting SQL Server savepoint operations for COMMIT and ROLLBACK when building both client applications and stored procedures. 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.

Note: 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.

Dependencies:

DIALECT=MAINFRAME automatically sets CHECKCALLPARAMS.

Scope:

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

Comment:

Separate each instance of OPTION with a space.

Example:

SQL(OPTION=CHECKCALLPARAMS OPTION=NORSLOCATORS)