Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Unanswered: how to print out message in db2

    HI guys

    I'm new for db2. Could you tell me how to print out message in db2 store procedure developed by sql. Just something like java system.out.println.

    Another issue is I used command center today. But I can't edit the script in multiple lines. Just like

    select *
    from table1

    when I run it , I got an error. I'm wondering if I need do things like that

    select * \
    from table1


    Thank you in advance.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    http://www-106.ibm.com/developerwork...0302izuha.html

    for your second question,

    you do not need a continuation character in db2 .... Rather you need a termination character, which is defined in under 'Options' in Command Centre ... By default, the termination character is ;
    select *
    from table1 ;
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2004
    Posts
    1

    Thanks

    Thanks for your answer

  4. #4
    Join Date
    Mar 2004
    Posts
    46
    In answer to your first question - how to print from a stored procedure, I believe that's not possible. Remeber that stored procedures/functions/routines are run on the backend/server - and the only form of input/output is parameters.

    There is not way to "enable" serveroutput like in Oracle (or other RDBMSes).

Posting Permissions

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