The following shows how to transport, export or import data when Loader CLI is in session mode.
You require the demo databases DEMODB and TESTDB. Start the Loader in session mode: loadercli [<options>]. Enter the necessary Loader commands and SQL statements. To end the session mode, enter release or exit.
Example
loadercli -d demodb -u mona,red -s hotel
The Loader establishes a connection to the demo database DEMODB for the database user MONA in the schema HOTEL. The Loader then waits for the commands and SQL statements in the command line, and processes them.
Example
loadercli -d demodb -u mona,red -cs ;
The Loader establishes a connection to the database DEMODB for the database user MONA. The Loader waits for the commands and SQL statements in the command line. These must each be completed with a semicolon for Loader to process them.
You have already executed an export with the Loader in transport mode. The package directory <loader_user_data>\packages\export\GENUA\DEMODB\20060322101010 contains the command file 20060322101010.EXPORT.
You can execute the commands contained in the command file in session mode. To do this, proceed as follows:
Start the Loader in session mode:
loadercli -d demodb -u mona,red -s hotel -E 10 -cs //
Copy the required commands from command file 20060322101010.EXPORT into the console input to describe the export. Note that you may have to remove or alter information about the users. Each command line must be completed with // for Loader to process it.
Exit the session mode.