Lesson 3: Creating the remote database

From the c:\tutorial\rem directory, run the following command to create the remote database (rem):

dbinit -dba DBA,sql rem.db

In this lesson, you use dbxtract to create the remote database. Run the following command to extract the database for the
rem user from the consolidated database, and leave the database server for the remote database running after the extraction:

If you are not currently connected to the remote database (rem), run the following command:

dbisql -c "SERVER=rem;DBN=rem;UID=DBA;PWD=sql"

The consolidated database uses the FILE message system, so when dbxtract runs, it creates SQL Remote definitions assuming
that the rem remote database is also using the FILE message system. To configure the remote database to use the HTTP message
system, execute the following statements on the remote database (rem) to remove the FILE message system for this remote database:

Verify that the remote database (rem) contains the two rows of data that existed in the consolidated database after the extraction;
Execute the following statement to view the contents of the employees table:

SELECT * FROM employees;

The query returns the following data from the employees table, although the hire_date column contains the time you inserted
the row, and not the values you see in the following table:

employee_id

first_name

last_name

hire_date

1

Kelly

Meloy

2011-03-25 08:27:56.310

2

Melisa

Boysen

2011-03-25 08:27:56.310

Disconnect from Interactive SQL.

Résultat

The remote database is extracted and the FILE message system at the remote database is replaced with the HTTP message system.