Show TOC

Background documentationSession Mode Locate this document in the navigation structure

 

The following shows how to transport, export or import data when Loader CLI is in session mode.

Prerequisites

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.

Activities

Calling the Loader CLI in Session Mode

Example Example

loadercli -d demodb -u mona,red -s hotel

End of the example.

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 Example

loadercli -d demodb -u mona,red -cs ;

End of the example.

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.

Creating a Command in Transport Mode and Executing it in 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 alter information about the users. Each command line must be completed with // for Loader to process it.

  3. Exit the session mode.