Chapter 14. Utilities and Options Reference
Reloadthe data to an existing database (–ac) Youcan combine the
operationof unloading a database and reloading the results into an existing
databaseusing this option.
Forexample, 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
databasefile named
newdemo.db:
dbxtract -c "uid=dba;pwd=sql;dbf=asademo.db"
-ac "uid=dba;pwd=sql;dbf=newdemo.db" field_user
Ifyou use this option, no copy of the data is created on disk, so you do not
specifyan unload directory in the command. Thisprovides greater security
foryour data, but at some cost for performance.
Donot star t subscriptions automatically (–b) Ifthis option is selected,
subscriptionsat the consolidated database (for the remote database) and at
theremote database (for the consolidated database) must be started explicitly
usingthe START SUBSCRIPTION statement for replication to begin.
Connectionparameters (–c) Aset of connection parameters, in a string.
♦dbxtractconnection parameters Theuser ID should have DBA
authorityto ensure that the user has permissions on all the tables in the
database.
Forexample, the following statement (which should be typed on one line)
extractsa database for remote user ID joe_remote from the
asademodatabaserunning on the sample_server server, connecting as user ID
DBAwith password SQL. The data is unloaded into the
c:\unloaddirectory.
ssxtract -c "eng=sample_server;dbn=sademo;
uid=dba;pwd=sql" c:\extract joe_remote
Ifconnection parameters are not specified, connection parameters from
theSQLCONNECT environment variable are used, if set.
♦ssxtractconnection parameters Thefollowing connection parameters
aresupported:
307