Loading Data into the Multiplex

Use the coordinator and writer to load the multiplex to make the best use of multiplex resources.

1. In the Administration Console right pane, highlight the coordinator in the Server column.
2. Hover to the right of the server name, click the dropdown arrow, and select Execute SQL.
   Interactive SQL starts with a connection to the coordinator.
3. In Interactive SQL, enter:

   TRUNCATE TABLE Contacts;
   LOAD TABLE Contacts (ID, Surname,GivenName,
   Title, Street, City, State, Country, PostalCode,
   Phone, Fax, CustomerID)
   USING FILE '../IQ-16_0/demo/adata/contact.dat'
   ROW DELIMITED BY '|'
   ESCAPES OFF;
   COMMIT;

   Enter the full path to the data file on a single line.
4. Press Execute to load the Contacts table on the coordinator.
5. Close Interactive SQL.
6. In the Administration Console right pane, highlight the <localhost>-iqdemo_w1 in the Server column and choose Execute SQL.
   Interactive SQL starts with a connection to the writer.
7. In Interactive SQL, enter:

   TRUNCATE TABLE SalesOrderItems;
   
   LOAD TABLE SalesOrderItems (ID, LineID,
   ProductID, Quantity, ShipDate)
   USING FILE '../../IQ-16_0/demo/adata/sales_oi.dat'
   ROW DELIMITED BY '|'
   ESCAPES OFF;
   COMMIT;

   Enter the full path to the data file on the single line.
8. Press Execute to load the SalesOrderItems Table on the writer.
9. Close Interactive SQL.