Loading Data into the Multiplex

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

Prerequisites

The coordinator and writer are started.
The SAP Sybase IQ Agent is registered and authenticated.

Task

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 run. Change the path in the code samples to point to the directory where the code samples are located, if necessary.

In the Administration Console right pane, highlight the coordinator in the Server column.
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.

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:\ProgramData\SybaseIQ\demo\adata\contact.dat'
ROW DELIMITED BY '|'
ESCAPES OFF;
COMMIT;

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

Press Execute to load the Contacts table on the coordinator.
Close Interactive SQL.
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.

In Interactive SQL, enter:

TRUNCATE TABLE SalesOrderItems;

LOAD TABLE SalesOrderItems (ID, LineID,
ProductID, Quantity, ShipDate)
USING FILE 'C:\ProgramData\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 Execute to load the SalesOrderItems Table on the writer.
Close Interactive SQL.