Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007

    Unanswered: Set server output on

    Hi all,

    Is there any command in DB2 like in oracle which says "SET SERVEROUTPUT ON" Thank you all in advance

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    For those of us who do not know oracle, what does the command do? Also list DB2 version and OS.


  3. #3
    Join Date
    Jan 2007
    Jena, Germany
    You didn't care to tell us what this Oracle command is doing. So I can only guess that it allows you to write to standard output/error? This option is only useful for debugging - production systems are usually multi-tiered, and your application cannot access the database server directly. For debugging purposes, there are several options how you can write data to either a (temp) table in DB2 or to an external file. I explained a few UDFs for that here, for example:
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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