Hi all,

I have a code here (modified from InfoCenter). I receive the email OK,
but for some reason the message body won't show up in the email. Even
the version from InfoCenter does the same thing.

Anyone has any experience with this issue before? Thanks.

BEGIN
DECLARE v_sender VARCHAR(30);
DECLARE v_recipients VARCHAR(60);
DECLARE v_subj VARCHAR(200);
DECLARE v_msg VARCHAR(200);

SET v_sender = 'db201@test.com';
SET v_recipients = 'dba@test.com';
SET v_subj = (select 'DB2 Mail Test' from sysibm.sysdummy1);
SET v_msg = 'This is a test message from db2 mail';
CALL UTL_MAIL.SEND(v_sender, v_recipients, NULL, NULL, v_subj,
v_msg);
END@

http://publib.boulder.ibm.com/infoce...Fr0055180.html