Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    6

    Unanswered: debugging db2 stord procedure

    Hi all,

    Is there any way by which a db2 stored procedure can be debugged something like dbms_output.put_line in oracle .
    Please reply urgently

    Regards,
    Parijat

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

    1) Use the Debug facility provided by Dev Centre (was known SPB in V7). You can build the proc for debug and run in debug mode by stepping through each line in your SP . You can also create breakpoints
    2) Use the sample UDF provided in http://www-106.ibm.com/developerwork...0302izuha.html


    HTH

    Sathyaram
    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
  •