Working with Stored Procedures

Important: Any machine on which a COBOL stored procedure is executed must have a Micro Focus Enterprise Server or COBOL Server product installed and licensed. Contact Customer Care for more information.

To get a stored procedure up and running:

  1. To set up the initial environment:

    Windows:

    Do one of the following

    • Add your installation's executable (bin) directory to the PATH statement
    • Copy the following DLLs to the directory from which you execute the stored procedure. You need to do this for DB2 to be able to execute a COBOL stored procedure:
      • cblrtsm.dll
      • cblviom.dll
      • mffh.dll
      • mfhcolib.dll
      • mfsqlsmf.dll

    In addition, see the IBM documentation for Building Micro Focus COBOL Routines on Windows.

    UNIX:

    See the IBM documentation for Building Micro Focus COBOL Routines on UNIX.
  2. Code and prepare a stored procedure. See the topic Writing and Preparing Stored Procedures for instructions.
  3. Code and prepare an application that calls the stored procedure. An SQL statement, CALL, in that application must use the same parameter list and linkage convention as the stored procedure that it invokes. For instructions, see Writing and Preparing Applications to Use Stored Procedures.
  4. Define your stored procedure to the DB2 LUW Server by issuing a CREATE PROCEDURE command, which places a row in the appropriate system table(s). See Defining Stored Procedures under DB2 LUW for details.
  5. Compile and link your stored procedure. See Compiling and Linking Stored Procedures under DB2 LUW for details.
  6. Test your stored procedure. See Testing Stored Procedures under DB2 LUW for details.