Stored Procedures Test Tool

The Stored Procedure Test tool (SP Test tool) makes the testing of stored procedures easier. It enables you to test various input values for a stored procedure, see the results, and optionally create test scripts without having to write COBOL code to invoke the stored procedure. However, if you want to invoke the stored procedure from a COBOL program, the tool also provides an option that enables you to generate such a program containing all of the required COBOL host variables.

The Stored Procedure Test tool also provides three wizards that enable you to generate both the SQL and the COBOL code for stored procedures, external table functions, and external scalar functions:

The SP Test tool accesses your stored procedures by connecting to the XDB server you specify, building a list of stored procedures and functions defined for that server.