Running the example queries on log files using DM Query
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.
3 From the Metadata Type list, select UNICOM Intelligence Log File (read-only).
4 Enter the Metadata Location. If you want to view a specific log file, click Browse and select the log file in the Open dialog. If you want to view all of the log files in a folder, enter the name and location of the folder.
If you specify a folder, Log DSC will select all of the files that have a .tmp filename extension in that folder. However, some log files might have another filename extension. If necessary, rename any files so that they have a .tmp filename extension.
5 From the Case Data Type list, select None.
6 Leave the Case Data Location and Case Data Project text boxes blank.
7 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 easier to understand.
8 Click OK to return to the DM Query window.
9 Type the SQL query into the text box, and then press Enter.
The results of the query are displayed in the DM Query window.
Requirements
UNICOM Intelligence Data Model
See also