Contents 

SQL Data Sets - Online help

Prev Page Next Page

Opening and using a SQL Data Sets package

From the earlier example, you would now have created a SQL Data Sets package. You can now open the package file using SQL Data Sets, or the free SQL Data Sets Viewer.

Select the File > Load SQL Data Sets package menu item,

mainmenu-loadpackage

or click on the Load SQL Data Sets package
toolbar item.

Select the package file you created earlier.

selectpackage

Enter the password you entered to protect the package with.

password02

SQL Data Sets opens the package file, and displays the 2 data sets contained in that package. The comments that we entered earlier are also displayed in the SQL workspace.

gs07

If we open the second data set, the note that we saved earlier for ProductID 168 is also displayed as a hint.

gs13

If we select that cell, the note is displayed in the Notes
area.

gs14

We can still run queries against the result sets, without having to connect to any database server. Here, we are running a query that shows us the aggregate order quantity grouped by territory.

gs08

And that's it with regards to opening and using a SQL Data Sets package. There is still much more your users can do with a package, like exporting the data sets, running local queries across multiple data sets, viewing and exporting binary data, and even creating their own packages.