The UNICOM Intelligence Data Model supports basic update, insert, and delete statements. The truncate statement is supported in UNICOM Intelligence Data Model 2.8 and later. The select into statements are not supported. Most data manipulation should occur using the ADO recordset interface.

The examples in this section use the UNICOM Intelligence Data File version of the Museum sample data set, which is based on a survey of visitors to a museum. The files are called museum.mdd (which contains the metadata) and museum.ddf (which contains the case data), and by default both files are in:

Before running the examples, use the Windows Explorer to make copies of the files and then make sure that the copies do not have the Read-only attribute set. You can run this example using the DM Query sample tool, which is supplied with the UNICOM Intelligence Developer Documentation Library. To set up DM Query, see How to run the example queries in DM Query using the museum sample; make sure that you select your copies of the museum sample files and not the original files.

The examples were run using the connection option to return category names rather than category values. You select this option on the Advanced tab in the Data Link Properties dialog: see Data Link Properties: Advanced.