Loading Data into the Multiplex

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

Because we want to load the same data we used to create the demo database, the sample LOAD scripts include a TRUNCATE statement, which deletes all rows in the target table before loading the data.

Note: The code samples in this task include an absolute path to the load scripts. This path should point to the %ALLUSERSPROFILE%\SybaseIQ\demo\adata directory. The value of the %ALLUSERSPROFILE% variable depends on the version of Windows that you are running. Change the path in the code samples to point to directory where the code samples are located, if necessary.

In Folders, right-click <localhost>_iqdemo > Open Interactive SQL.
This starts Interactive SQL with a connection to the coordinator.

In Interactive SQL, enter:

TRUNCATE TABLE Contacts;
LOAD TABLE Contacts (ID, Surname,GivenName,
Title, Street, City, State, Country,
PostalCode, Phone, Fax, CustomerID)
USING FILE
'C:\Documents and Settings\All Users\SybaseIQ\demo\adata\contact.dat'
ROW DELIMITED BY '|'
ESCAPES OFF;
COMMIT;

Enter the full path to the data file on a single line.

Press F9 to load the Contacts table on the coordinator.
Close Interactive SQL.
In Folders, right-click <localhost>_iqdemo_w1 > Open Interactive SQL.
This starts Interactive SQL with a connection to the writer.

In Interactive SQL, enter:

TRUNCATE TABLE SalesOrderItems;
LOAD TABLE SalesOrderItems (ID, LineID,
ProductID, Quantity, ShipDate)
USING FILE 'C:\Documents and Settings\All Users\SybaseIQ\demo\adata\sales_oi.dat'
ROW DELIMITED BY '|'
ESCAPES OFF;
COMMIT;

Enter the full path to the data file on the single line.

Press F9 to load the SalesOrderItems Table on the writer.
Close Interactive SQL.