SPCALLLOCAL

For native HCOSS applications, transforms an SQL call to a SQL Server stored procedure (i.e., an EXEC SQL CALL statement) into a standard COBOL call to a local COBOL subroutine.

Restriction: This topic applies to Windows environments only.

Syntax:

[NO]SPCALLLOCAL

Properties:

Default:

NOSPCALLLOCAL

Dependencies:

Must be used with DIALECT=MAINFRAME and DBMAN=ODBC.

Scope:

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

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

Comments:

Some applications perform better when you replace SQL Server calls to stored procedures with local COBOL subroutines. This can be applicable, for example, to HCOSS applications that call a given stored procedure multiple times.