Generate SPD File tool

The Generate SPD File tool enables you to generate stored procedure definition (SPD) files from an extracted DB2 schema. You can use a generated SPD file to generate a COBOL wrapper.

The Generate SPD File tool provides the following functionality:
  • Enables you to select one or more stored procedures from a Schema Extract file.
  • Generates selected stored procedures into a stored procedure definition file.
  • If HCOSS is opened from within the IDE and a SQL Server Database project is open in Visual Studio, the Generate SPD File tool can also generate a COBOL wrapper program that executes the stored procedures in the SPD file, and include both the SPD file and the generated program in the current project.

Before using the SPD Generator tool, review the following scenarios to help you determine how to best use the tool for any given application or project: