Session Mode

Below are instructions for transporting, exporting or importing data when the Loader CLI is in session mode.

Prerequisites

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.

See also:

Loader, Session Mode

Examples

Calling the Loader CLI in 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.

Creating a Command in Transport Mode and Executing it in the Session Mode

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.

See also:

Transport Mode

Command File Mode

Loader, Log File