Below are instructions for transporting, exporting or importing data when the Loader CLI is in session mode.
You require the demo databases DEMODB and TESTDB.
Start the Loader in the session mode: loadercli [<options>]
Enter the necessary Loader commands and SQL statements. To end the session mode, enter release or exit.
Loader, Session Mode
loadercli -d demodb -u mona,red -s hotel
The Loader establishes a connection to the database instance DEMODB for the user MONA in the schema HOTEL. The Loader then waits for the commands and SQL statements in the command line, and processes them.
loadercli -d demodb -u mona,red -cs ;
The Loader establishes a connection to the database instance DEMODB for the 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:
1. Start the Loader in session mode:
loadercli -d demodb –u mona,red –s hotel –E 10 –cs //
2. 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 adjust information about the users. Each command line must be completed with // for Loader to process it.
3. Exit the session mode.
Loader, Log File