To update the location for an Informix MetaCube using the MetaCube SQL method

1. On the Database menu, click Set Location.

   The Set Location dialog box appears.

2. Select the Database, then click Set Location.

   The Data Explorer appears.

3. Select the table.
4. Click Set.

   The Propagate Set Location dialog box appears.

5. Click Yes.
6. Click Done.