CHECKSP

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

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 either manually or by using the Generate SPD File tool.

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:

You must specify the SPD file that was generated for the original stored procedure so that CHECKSP can use it to find information about the parameters to the called routine.

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.