You can import new results sets from XML and HTML tables, as well as text files. You can import data from a local file, as well as from a URL.
To import a new results set:
1. In the Results branch of the desired connection in the DB2 Web Query navigation tree, click any item.
A drop-down menu appears.
2. From the drop-down menu, select New.
The Import Results page appears.
3. Select the type of file from which you want to import a results set.
4. Specify the location of the file from which you want to import a results set.
You can specify either a local file on your computer, or a URL.
5. Click Next.
The Options page for the file type that you selected appears.
6. Select the Import Options for the file type from which you want to import a results set, and click Next.
The Import Options page appears.
7. Select the number of rows to import, name of the result file, Locale, and Null Value for the results set you are importing.
Tip: Choose the Locale and Null Value as they appear in the file you are importing from so that DB2 Web Query can read dates, times, timestamps, numbers, and null values correctly.
8. Select which columns to include. Indicate the data type of that column. Use the Format field to specify a format string to apply to the data in that column. Use the Match field to import only rows which contain the value you enter in that column.
If you do not specify a format for a date, time, timestamp, or number data type, DB2 Web Query uses the format for your selected Locale.
Tip: Click Sample Data to display rows from the results set you are importing in the Sample Data Viewer, so you can select the appropriate column options.
9. Click Next.
DB2 Web Query imports the results set, and displays a confirmation message.