Hi ,

I would like to know how to we see the output of "MESSAGE_TEXT " .
Below is 1 such procedure ..

create procedure mess_test (out p_sqlstate char(5) , out p_sqlcode
int )
language sql
specific mess_test
begin
declare v_count int;
declare sqlstate char(5) default '00000';
declare sqlcode int default 0;
DECLARE c_too_many_rows CONDITION FOR SQLSTATE '99001';
--declare no_table condition for sqlstate '42704';
declare exit handler for sqlexception
select sqlstate , sqlcode into
p_sqlstate , p_sqlcode
from sysibm.sysdummy1;
       select count(*) into v_count from employee;
       if v_count > 30 then
       signal c_too_many_rows set message_text = ' Rows More thena
required ';
       end if;

end
DB20000I  The SQL command completed successfully.

^C
D:\>db2  call mess_test(?,?)

 Value of output parameters
 --------------------------
 Parameter Name  : P_SQLSTATE
 Parameter Value : 99001

 Parameter Name  : P_SQLCODE
 Parameter Value : -438

 Return Status = 0

D:\>

I am unable to see the " message_text " out put .
How can we see that . Is their any setting to be changed while
executing or calling the procedure ,.
Please let me know about this .
Thanks a lot .
Bikash Karan