Previous Topic Next topic Print topic


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.

Previous Topic Next topic Print topic