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

Run the following command:

dbinit SIS_CarDealer_LP_DBLSN_REM

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

Run the following command:

dbeng12 SIS_CarDealer_LP_DBLSN_REM

Connect to your MobiLink client database using Interactive SQL.

Run the following command:

dbisql -c "SERVER=SIS_CarDealer_LP_DBLSN_REM;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 CarDealer(TABLE DEALER WHERE 0=1)
CREATE SYNCHRONIZATION USER test_mluser OPTION ScriptVersion='CarDealer'
CREATE SYNCHRONIZATION SUBSCRIPTION TO CarDealer FOR test_mluser
SET OPTION public.ml_remote_id = remote_id;
COMMIT;

Proceed to Lesson 7: Configuring the MobiLink Listener.