Loading Data into the Multiplex

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

1. In Folders, right-click <localhost>_iqdemo > Open Interactive SQL.
   This starts Interactive SQL with a connection to the coordinator.
2. 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-15_4/demo/adata/contact.dat'
   ROW DELIMITED BY '|'
   ESCAPES OFF;
   COMMIT;

   Enter the full path to the data file on a single line.
3. Press F9 to load the Contacts table on the coordinator.
4. Close Interactive SQL.
5. In Folders, right-click <localhost>_iqdemo_w1 > Open Interactive SQL.
   This starts Interactive SQL with a connection to the writer.
6. In Interactive SQL, enter:

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

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