Previous Topic Next topic Print topic


CHECKSP

Checks the parameters set for the SPCALLLOCAL directive to ensure that they match the SPD definition.
Restriction: This topic applies to Windows environments only.

Syntax:

CHECKSP=SPDFileName

Properties:

Default: None

Parameters:

SPDFileName
The SPD file that was generated for the original stored procedure 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.

Previous Topic Next topic Print topic