Previous Topic Next topic Print topic


Testing a Stored Procedure

Restriction: This topic applies to Windows environments only.

Once you have started and configured the SP Test tool, you are ready to test your stored procedures. These are listed on the IDE by schema name in the tree view on the left under Stored Procedures. The procedure to test a stored procedure is as follows:

  1. Set input and output parameters
  2. Specify filenames for generated files
  3. Execute the stored procedure
  4. Read the results
Previous Topic Next topic Print topic