Stored procedure sample without result set

Db2 provides a sample stored procedure that uses the instrumentation facility interface (IFI) to issue Db2 commands. The sample stored procedure also returns the responses to the calling program in a parameter.

This sample application consists of two jobs: DSNTEJ6S and DSNTEJ6P. These jobs are part of the installation verification samples, which are located in prefix.NEW.SDSNSAMP. The installation CLIST tailored and loaded these jobs during your installation or migration.

Requirements: You must satisfy the following requirements when running these jobs:
  • Run job DSNTEJ6S before job DSNTEJ6P.
  • Ensure that the PL/I product is installed on your client and server systems.
  • Ensure that Language Environment® is installed.

This application prepares and runs the following programs:

  • A stored procedure that uses the IFI to issue Db2 commands.
  • A client program that receives Db2 command text and calls the stored procedure to issue the commands. When the program receives the responses from the stored procedure in a parameter that is passed back, it prints the results.

For concurrent installations at two Db2 locations, perform the following actions:

  • Run the server version of DSNTEJ6S on the server system only; do not run the client version of DSNTEJ6S on the server.
  • Run the client version of DSNTEJ6P on the client system only; do not run the server version of DSNTEJ6P on the client.