Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006

    Unanswered: Stored Procedure output edit

    Here is what I need help with.

    1) I have a stored proc that declares a cursor and pulls a set of records.
    2) The stored proc is invoked through CLP (db2 x call sp > outFile) and the resulting records are stored in the outFile.
    3) In addition to storing the records, the invocation also stores the header/Status strings such as: Result set 1, ----------, Return Status = 0
    4) I need to know if we could avoid outputting the strings: : Result set 1, ----------, Return Status = 0
    5) I have tried x already and it did not work. I also tried the w and still have the problem.

    Thanks for any help.

  2. #2
    Join Date
    Aug 2001
    AFAIK, it is not possible ... You have to discard those lines - say using a script ..

    I wish to be proved wrong!

    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