Hello everyone, I have a scenario where I am truncating the column table (HDBTABLE) inside the stored procedure as shown below. There is no explicit COMMIT/ROLLBACK statement used in the stored procedure. I believe TRUNCATE statement being DDL, ...

Hello everyone, Whenever I send an email from the BODS using SMTP function, some default messages will be printed before printing the actual body of the email. Default message is as shown below. Mail from: </job name> sent at: < date time > Mess...

Hello Everyone, I am using SMTP function to send an email in case of error(s). I want to send a message of failure along with the list of reasons of failure. In case of multiple reasons of failure, each reason should be printed in a new line i...