User's Manual

Chapter 14. Utilities and Options Reference
Reload the data to an existing database (–ac) You can combine the
operation of unloading a database and reloading the results into an existing
database using this option.
For example, the following command (which should be entered all on one
line) loads a copy of the data for the field_user subscriber into an existing
database file named newdemo.db :
dbxtract -c "uid=dba;pwd=sql;dbf=asademo.db"
-ac "uid=dba;pwd=sql;dbf=newdemo.db" field_user
If you use this option, no copy of the data is created on disk, so you do not
specify an unload directory in the command. This provides greater security
for your data, but at some cost for performance.
Do not start subscriptions automatically (–b) If this option is selected,
subscriptions at the consolidated database (for the remote database) and at
the remote database (for the consolidated database) must be started explicitly
using the START SUBSCRIPTION statement for replication to begin.
Connection parameters (–c) A set of connection parameters, in a string.
♦ dbxtract connection parameters The user ID should have DBA
authority to ensure that the user has permissions on all the tables in the
database.
For example, the following statement (which should be typed on one line)
extracts a database for remote user ID joe_remote from the asademo
database running on the sample_server server, connecting as user ID
DBA with password SQL. The data is unloaded into the c:\unload
directory.
ssxtract -c "eng=sample_server;dbn=sademo;
uid=dba;pwd=sql" c:\extract joe_remote
If connection parameters are not specified, connection parameters from
the SQLCONNECT environment variable are used, if set.
♦ ssxtract connection parameters The following connection parameters
are supported:
307