I'm trying to send mail from DB2 using the procedure UTL_MAIL. I'm using the DB2 Express Edition 10.1. First I was getting the error of SMTP Server. After using the below command,
update admin cfg using smtp_server LOCALHOST
I am using the following command to send the mail:
CALL UTL_MAIL.SEND('firstname.lastname@example.org','email@example.com',NULL,NULL,'Test Email','Test body')
Now I am getting the following error:
SQL1336N The remote host "" was not found. SQLSTATE=08001
I searched a lot and found out that I must CATALOG the server details.
Can anyone please help me regarding this?