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.

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 ;

Thanks for your answer

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).