Data Model > UNICOM Intelligence Data Model samples > UNICOM Intelligence Data Model-related sample code > DM Query
 
DM Query
DM Query is a simple query tool that works directly on the UNICOM Intelligence Data Model.
Getting started with DM Query
For information on using DM Query, see Running the example queries in DM Query.
Source code
The DM Query source code is provided as a reference for developers who are creating applications using the UNICOM Intelligence Data Model. The UNICOM Intelligence Developer Documentation Library comes with two versions of the source code:
Visual Basic .NET. The source code is installed to the [INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\Code\Tools\VB.NET\DM Query folder. Features include the following:
The Visual Basic .NET version is a single-document interface (SDI) application because it makes the code simpler and easier to understand.
Visual Basic .NET has the ability to save and open Data Link (.udl) files. You can also specify a .udl file on the command line when starting up the application. This means you can drag a .udl file onto DM Query to start it up.
In the Visual Basic .NET, you can specify a SELECT query that will run automatically after every INSERT, DELETE, or UPDATE statement, so that you can see the results of your data manipulation straight away. To specify the SELECT query, choose Current Query from the View menu. To run the SELECT query immediately, choose Refresh from the View menu. To make the SELECT query run automatically after every data manipulation statement, choose Refresh Automatically from the View menu.
Other new features in the Visual Basic .NET include the ability to view the contents of the connection string for the current connection and to resize the SQL text box and to enter multiple lines.
Executable files
An executable file is provided for both versions of DM Query. The files are called DM Query.exe and by default are installed into the same folder as the source code.
For some examples of using the Visual Basic .NET version of DM Query, see Understanding the MDM integration.
What's new
DM Query now provides support for hierarchical data.
See also
Understanding hierarchical data
Running the example queries in DM Query
Understanding the MDM integration
UNICOM Intelligence Data Model-related sample code