In session mode, the user can transfer Loader commands and SQL statements to Loader directly from the console.
You can start Loader CLI in session mode by entering the following command:
Syntax
loadercli
If you want to transfer further information when Loader CLI is called, use the corresponding options.
Syntax
loadercli [<connect_options>] [<in_output_options>] [<version_options>]
You can enter options for establishing the connection, for input and output control, and for version queries. After starting Loader CLI in session mode, you can enter Loader commands and SQL statements interactively.
-d <database_name> |
Name of database |
-u <database_user>[,<password>] |
Name and password of database user |
-n <database_computer>[:<port>] |
Name of database computer |
-s <schema_name> |
Name of schema |
-e <encryption> |
Encryption method |
More information: Opening a Database Session: Loader CLI Options
-o[w|a] <file_name> |
Name of output file |
-cs <separator> |
Command separator |
-ps<number> <string> |
Substitution parameter |
-E <number> |
Maximum number of errors allowed |
More information: Input and Output: Loader CLI Options
-V |
Version of Loader server |
-v |
Version of Loader CLI |
-R <dependent_path> |
Directory containing the programs that are dependent on the version of the database software |
More information: Determing Version Information: Loader CLI Options
The default value for a command separator is ENTER. If you enter a Loader command that is longer than one line and you end one of these lines with a forward slash (/), Loader CLI recognizes that the command is not yet complete. It is not yet executed when the command separator ENTER is inserted. Only when you enter the command separator ENTER without preceding it with a forward slash does Loader CLI recognize that the command is complete.
You can change this behavior by defining another command separator with the option –cs <command_separator>. If, for example, you define the semicolon as the command separator, you can write multiple lines until Loader finds a semicolon. Only when you enter the command separator “semicolon” does Loader CLI recognize that the command is complete.
Once the command separator is received, the command is sent to the Loader server, which executes it. After execution of all the Loader commands and SQL statements, Loader CLI displays a message. To end session mode, enter release or exit, followed by the command separator.
Example
loadercli -d demodb -u mona,red -s hotel
Loader establishes a connection to the database DEMOB for the user MONA in the scheme HOTEL. Loader then waits for the Loader commands and SQL statements in the command line. Loader only processes them when you end the commands with ENTER.
Example
loadercli -d demodb -u mona,red -cs ;
Loader establishes a connection to the database DEMOB for the user MONA. Loader waits for the Loader commands and SQL statements in the command line. Loader only processes them when they you end them with a semicolon.
For more examples, see the Loader Tutorial, Session Mode.