Object documentationCommand File Locate this document in the navigation structure

 

When you call Loader with Loader CLI, you can transfer the Loader commands and SQL statements to be evaluated to Loader in a special file, the command file.

 

If you want to call Loader in command file mode, you have to specify the name of the command file using option –b <command_file>. If required, you can transfer further options (Opening a Session: Loader CLI Options).

Structure

Note the following syntax rules for command files:

  • General Syntax Rules: The same syntax rules apply as for calling Loader (Calling the Loader).

  • Separator Line Between Commands: Individual commands in a command file are separated by a line beginning with a double forward slash //. When you call Loader CLI, you can use the option –cs to define a different command separator (Input and Output: Loader CLI Options).

  • Comments: You can enter comments after a double forward slash // at the start of the line. Loader ignores the comments when the command file is processed.

Example

Example Example

loadercli -d demodb -u mona,red -n genua -b command.dat

End of the example.

The name of the database, the database user information, and the computer name are transferred using the relevant options. The Loader commands and SQL statements are in the command.dat file. The Loader commands and SQL statements that you specify in the command file are processed by Loader in the specified order.

Loader-Tutorial, Command File Mode

More Information

A command file can also be generated by generating the design data in transport mode.