extractDataAll(executionLocation: Integer; scriptFilePath: String; dataFilesPath: String; rdbDataFilesPath: String; rdbName: String; extractHistoricalTables: Boolean; serverName: String; extractWorkers: Integer; extractOrder: Integer; extractFirst: String; userDataPumpSchema: String; userDataPumpApp: String): Process;
The extractDataAll method of the RelationalView class starts the user-defined RPS Datapump application specified by the userDataPumpApp and userDataPumpSchema parameters on the server node to extract data for all tables on an SDS secondary or RPS node.
This method does not apply to ODBC relational views.
You can execute this method on an SDS secondary or an RPS node, but not on the primary node. Running an RPS extract on an SDS node causes tracking to be stopped during the extract.
The extractDataAll method parameters are listed in the following table.
Parameter | Specifies the … | ||||||||
---|---|---|---|---|---|---|---|---|---|
executionLocation | The location that will be used for loading the extracted data. Allowed values can be specified using the Load_ServerExecute (0) and Load_ClientExecute (1) RelationalView class constants. | ||||||||
scriptFilePath | The output directory for the script files. | ||||||||
dataFilesPath | The output directory for the data files. | ||||||||
rdbDataFilesPath | The path of the data files directory from the perspective of the RDBMS database. | ||||||||
rdbname | The name of the RDBMS database. | ||||||||
extractHistoricalTables | If historical table data is to be extracted. | ||||||||
serverName | The name of the RDBMS server. | ||||||||
extractWorkers | The number of extract worker processes to run. | ||||||||
extractOrder |
The order in which the tables are to be extracted; possible values specified by the RelationalView class constants listed in the following table.
|
||||||||
extractFirst | The names of the tables to be extracted first, if any, delimited by semicolons. | ||||||||
userDataPumpSchema | The name of the schema for the user-defined Datapump application. If null, the default Datapump application is used. | ||||||||
userDataPumpApp |
The name of the user-defined data pump application. If executed on the primary, the user-defined data pump may not be used. The user-defined data pump may be used in an RPS or SDS node. The value of the user-defined Datapump application (or <default>) is written out to the |
The method returns the process of the application that extracts the table data. You can register to receive notifications for events occurring for the process that carries out the data extraction in the following table.
Process Class Constant | Value |
---|---|
RPS_EXTRACT_FAILED_EVENT | 202 |
RPS_EXTRACT_FINISHED_EVENT | 203 |
Calls to this method can raise the following exception.
JErr_RpsExtractRequestError : Error in parameters. See extended error text for details.