Create your MobiLink client database using the dbinit command line utility.

Run the following command:

dbinit remote1

Start your MobiLink client database using the dbeng12 command line utility.

Run the following command:

dbeng12 remote1

Connect to your MobiLink client database using Interactive SQL.

Run the following command:

dbisql -c "SERVER=remote1;UID=DBA;PWD=sql"

Create the Dealer table.

Execute the following SQL statements in Interactive SQL:

CREATE TABLE Dealer (
    name            VARCHAR(10) NOT NULL PRIMARY KEY,
    rating          VARCHAR(5),
    last_modified   TIMESTAMP DEFAULT TIMESTAMP
)
COMMIT;

Create your MobiLink synchronization user, publication, and subscription.

Execute the following SQL statements in Interactive SQL:

CREATE PUBLICATION car_dealer_pub (table Dealer);
CREATE SYNCHRONIZATION USER sis_user1;
CREATE SYNCHRONIZATION SUBSCRIPTION 
    TO car_dealer_pub 
    FOR sis_user1 
    OPTION scriptversion='sis_ver1';
COMMIT;

Proceed to Lesson 9: Configuring the MobiLink Listener.