Stored procedure sample with 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 result set.

This sample application consists of two jobs: DSNTEJ6T and DSNTEJ6D. 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 DSNTEJ6T before job DSNTEJ6D.
  • Ensure that C for z/OS® is installed.
  • 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 result set, it prints the results.

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

  • Run the server version of job DSNTEJ6T on the server side only; do not run it on the client side.
  • Run the client version of job DSNTEJ6D on the client side only; do not run it on the server side.