You can convert and view a saved results set using the DB2 Web Query email interface. Before you can use the email interface, your system administrator must authorize you as an email user for the database you wish to access.
To convert a results set using the email interface:
1. Email DB2 Web Query at the database you wish to access.
DB2 Web Query replies with the subject "DB2 Web Query SMTP Server".
2. Reply to the email. Between the { } following "cmd" at the end of the email, type "help", then send the reply.
DB2 Web Query replies with an email containing a list of possible commands.
3. Reply to the email. Between the { } following "cmd" at the end of the email, type "convert result".
4. If desired, type a format preference, such as "format:html", and a row limit, such as "rowlimit:50". You can also enter an alternate email address to send the results to, such as "email:you@youraddress.com".
5. Type the name of the results set you wish to convert.
For example, if you wish to convert the results set GROUP.RESULT to html, with a row limit of 50, and email the results to you@youraddress.com, the last line in your reply might look like this:
cmd {convert result format:html rowlimit:50 email:you@youraddress.com GROUP.RESULT}
6. Send the reply.
DB2 Web Query converts the results set according to your specifications.