DB2 Version 9.7 for Linux, UNIX, and Windows

NOOP procedure - Send the null command

The NOOP procedure sends a null command to the SMTP server. The NOOP has no effect on the server except to obtain a successful response.

Syntax


>>-UTL_SMTP.NOOP--(--c--+----------+--)------------------------><
                        '-,--reply-'

c: An input or output argument of type CONNECTION that specifies the SMTP connection on which to send the command.
reply: An optional output argument of type REPLY that returns a single reply line from the SMTP server. It is the last reply line if multiple reply lines are returned by the SMTP server.

EXECUTE privilege on the UTL_SMTP module.

This procedure can be invoked using function invocation syntax in a PL/SQL assignment statement.