Opening Results

 

DB2 Web Query allows you to export your query results to a separate file, so you can open, view and work with results in a variety of formats. Export options include:

XML Document

Delimited Text

XSL Document

HTML Document

Text Document

MS Excel

To open results:

1.         In the desired connection branch of the DB2 Web Query navigation tree, click Results.

The Results branch expands, listing Recent and Saved results sets.

2.         Select the results set that you want to open.

A drop-down menu appears.

3.         From the drop-down menu, select Open.

The Select Output page appears.

4.         Select the file format in which you want to open your results.

Note:     If you export your query results to XML, you can format the resulting document with an XML style sheet, also called an XSL document. To do so, select XSL Document, and click Next. Select the format in which you want your data to be displayed. There are three choices: Table, where your data is displayed in a table, List, where each record is an entry in the list, or Record Browser, where an HTML document is created which allows you to use First, Previous, Next and Back buttons to view data your data one record at a time. DB2 Web Query creates an XSL document based on your results set. When you customize the export options for your XML document (see Step 5), specify the file path and name of this XSL document.

5.         Optional: Customize the export options for your results.

a)    Click Options. The Export Options page opens.

b)    Customize the export options for your results.

c)    Click Save. The Select Output page opens.

6.          Select an action to apply to your results set. Select Download to save your results to a local or network drive, View to view your results in your web browser, or e-Mail to send your results to an email address.

7.         Select Formatting for dates, times, and numbers in your results set. Select either ISO format or a specific Locale to determine how dates, times, timestamps, and numbers appear in the exported document. Select a Style to determine how much information is included in dates and times in your exported results set.

8.         Click Next.

DB2 Web Query exports your query results according to the export options you specified.