To generate a stored procedure

  1. Start the Stored Procedure Test tool.
  2. Click Create a new Stored ProcedureCreate new stored procedure.
  3. Complete each page of the Wizard. For help on a specific page and help on a specific field or control on a page, click Help.
Note: The Wizard writes one COBOL and one SQL file containing the generated code. The location of these files is specified in your SP Test tool Options, and the filenames are as follows:
  • SQL file - procedurename.sql
  • COBOL file - procedurename.cbl