Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Question Unanswered: DB2 stored procs

    Hi,

    We have written some DB2 stored procedures. These are called by front end JSP applications.

    As of now for testing the SP, we wrote a stub program in cobol that calls the SP using SQL calls and passes the required paramerter values to the SP. This stub is in turn executed by a JCL.

    In this way, we could execute the SP. But is there any way to debug them line by line.

    I am pretty new to SP, please let me know.

    Thanks, vlimmu

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2 stored procs

    To debug line by line, you will have to use the Stored Procedure Builder(v7) or development centre (v8)

    Cheers

    Sathyaram

    Originally posted by vlimmu
    Hi,

    We have written some DB2 stored procedures. These are called by front end JSP applications.

    As of now for testing the SP, we wrote a stub program in cobol that calls the SP using SQL calls and passes the required paramerter values to the SP. This stub is in turn executed by a JCL.

    In this way, we could execute the SP. But is there any way to debug them line by line.

    I am pretty new to SP, please let me know.

    Thanks, vlimmu
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •