11.2.7 Remote Loading
11.2.7 Remote LoadingEDB*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.This feature is useful if you have a large amount of data to be loaded, and you do not want to create a large data file on the host running the database server.In addition, you can use the standard input feature to pipe the data from the data source such as another program or script, directly to EDB*Loader, which then loads the table in the remote database. This bypasses the process of having to create a data file on disk for EDB*Loader.
• 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.
• 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.