You can run a saved query 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 create a query 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 "run query".
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 query results to, such as "email:you@youraddress.com".
5. Type the name of the query you wish to run.
For example, if you wish to run the query GROUP.QUERY with a row limit of 50, email the results to you@youraddress.com, and view the results in html format, the last line in your reply might look like this:
cmd {run query format:html rowlimit:50 email:you@youraddress.com GROUP.QUERY}
6. Send the reply.
DB2 Web Query runs the query and returns the results according to your specifications.
Note: If the query contains variables, you will receive an additional email asking you to fill out the variables before DB2 Web Query runs the query.