To generate an external scalar function

  1. Start the Stored Procedure Test tool.
  2. Click Create a new (external) Scalar FunctionCreate new scalar function.
  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 - functionname.sql
  • COBOL file - functionname.cbl
Parent topic: How to...
Related concepts
Options
Related tasks
To generate a stored procedure
To generate an external table function