CHECKSP

Checks the parameters set for the SPCALLLOCAL directive to ensure that they match the stored procedure definition.

Restriction: This topic applies to Windows environments only.

Syntax:

CHECKSP=SPDFileName

Properties:

Default:

None

Parameters:

SPDFileName: A stored procedure definition (SPD) file, which is a flat file containing CREATE PROCEDURE statements extracted from the original stored procedure.

Dependencies:

Requires that DIALECT=MAINFRAME and SPCALLLOCAL also be set.

Scope:

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

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

Comments:

Be sure that the SPD file contains all stored procedure definitions required for CHECKSP to compare the definitions to the arguments used in calling programs.