The Generate SPD File tool enables you to generate stored procedure definition (SPD) files from 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.
- If any selected stored procedure contains a TIMESTAMP or DATE parameter, the Generate SPD File tool changes it to DATETIME2 and SMALLDATETIME respectively generates a post-deployment script file that alters the stored procedure after successful deployment to ensure compatibility between Java and SQL Server. However, if your application interfaces only with other COBOL applications, you have the option to edit the generated SPD file and change DATETIME2 back to TIMESTAMP and SMALLDATETIME back to DATE.
Note: If your project was created using the SQL Server Database Project template, and one or more of your selected stored procedures contains a DATETIME2 or SMALLDATETIME parameter, you must add the post-deployment script to the project manually before running the Generate SPD File tool.
