6.1.7 Remote Loading

Table of Contents Previous Next


6 Database Utilities : 6.1 EDB*Loader : 6.1.7 Remote Loading

EDB*Loader supports a feature called remote loading. In remote loading, the database containing the table to be loaded is running on a database server on a different host than from where EDB*Loader is invoked with the input data source.
The edbldr program must be installed on the client host on which it is to be invoked with the data source for the EDB*Loader session.
The control file must contain the clause INFILE 'stdin' so you can pipe the data directly into EDB*Loader’s standard input. See Section 6.1.3 for information on the INFILE clause and the EDB*Loader control file.
When invoking EDB*Loader, use the -h option to specify the IP address of the remote database server. See Section 6.1.4 for information on invoking EDB*Loader.
Use the operating system pipe operator (|) or input redirection operator (<) to supply the input data to EDB*Loader.
The following example loads a database running on a database server at 192.168.1.14 using data piped from a source named datasource.

6 Database Utilities : 6.1 EDB*Loader : 6.1.7 Remote Loading

Table of Contents Previous Next