How to run the example queries in DM Query using the museum sample
This topic explains how to run the example SQL queries using the DM Query tool.
1 In Windows Explorer, go to the folder in which the Visual Basic .NET version of DM Query was installed. By default, this is:
[INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\Code\Tools\VB.NET\DM Query
2 Double-click the DM Query.exe file.
This opens the DM Query window and the Connection tab in the Data Link Properties dialog box.
3 From the Metadata Type list, select Intelligence Metadata Document.
4 Enter the Metadata Location: Click Browse, navigate to the folder that the Museum sample UNICOM Intelligence Data (.ddf) File is in, and then select the Museum.mdd file. By default, the Museum example database is in:
[INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\Data\Data Collection File\
If the example uses the Museum sample XML data set, select the Museum.mdd file in:
[INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\Data\XML
5 From the Case Data Type list, select Intelligence Data File (read-write).
If the example uses the Museum sample XML data set, select Intelligence XML File (read-write).
6 Enter the Case Data Location: Click Browse, navigate to the folder in which the Museum sample UNICOM Intelligence Data (.ddf) File was installed, and then select the Museum.ddf file.
If the example uses the Museum sample XML data set, select the Museum.xml file in:
[INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\Data\XML
7 Leave the Case Data Project box blank.
8 Click the Advanced tab, and from the Categorical Variables list, select Return data as category names.
This makes queries run on categorical variables return the category names rather than the numeric category values. This makes the examples much easier to understand.
9 Click OK to return to the DM Query window.
10 Type the SQL query into the text box, and then press Enter.
The results of the query are displayed in the DM Query window.
See also