Loader
Calling the Loader
Call Options of the Loader CLI
Transport Mode
Transport Mode: Options
Transport Mode: Examples
Command File Mode
Command File
Session Mode
Options for Establishing a Connection
Options for Input and Output
Options for Determining Version Information
Call with the Java Interface of the Loader
Commands and SQL Statements
Creating a Database Session: Commands
AUTOCOMMIT Command
SET Command
SQLMODE Command
USE SCHEMA Command
USE SERVERDB Command
USE USER Command
Exporting: Commands
EXPORT DB Commands
EXPORT USER Commands
EXPORT SCHEMA Commands
EXPORT TABLE Commands
EXPORT COLUMNS Commands
Importing: Commands
IMPORT DB Commands
IMPORT USER Commands
IMPORT SCHEMA Commands
IMPORT TABLE Commands
IMPORT COLUMNS Commands
UPDATE COLUMNS Commands
Exporting and Importing: Syntax Elements
Transformation
Data
Data Stream
Data Types
Data Formats
COMPRESSED, FORMATTED, FORMATTED BINARY
Medium
Table Description
Column Description
Output Column
Importing Constants and Special Constants
Selecting Data Records
Position Description
Code Specification
Dates
Times
Time Stamp Specifications
Exporting and Importing Using Backup Tools from Other Providers
Importing and Exporting LONG Values
Restart
Log Functions
Log File
System Tables
CODEPAGE
TRANSFORMATIONMODEL
TRANSFORMATIONMONITOR
TRANSFORMATIONPACKAGES
TRANSFORMATIONRESOURCES
TRANSFORMATIONSTATISTICS
TRANSFORMATIONSTEPS
Syntax Rules: Overview
autocommit_command
bool_spec
catalog_instream_spec
catalog_outstream_spec
code_page_spec
code_spec
column_assignment
column_descriptor
column_id
column_id_spec
column_names
compare_operator
condition
configuration_instream_spec
database_name_statement
data_instream_spec
data_outstream_spec
date_spec
delimiter_spec
duplicates_clause
ebid_spec
export_columns_command
export_command
field_format
field_pos
format_spec
generate_spec
if_condition
import_columns_command
import_command
import_table_spec_command
instream_spec
int_spec
isolation_level_spec
lit_column_spec
load_column_spec
longfile_code_spec
longfile_spec
mediumtype_spec
noheader_spec
null_assign
null_condition
null_spec
number_spec
numerical_functions
order_clause
output_column
output_column_list
outstream_spec
package_outstream_spec
part_spec
remark_command
restart
round_or_trunc_spec
scale_spec
schema_spec
select_expression
separator_spec
sequence_number
set_column_spec
set_command
simple_column_spec
simple_condition
sql_mode
sql_mode_command
standard_code_spec
standard_date_mask
standard_time_mask
standard_timestamp_mask
stream_extract
stream_format_spec
table_name
table_spec
time_spec
timestamp_spec
update_columns_command
usage_spec
use_schema_command
use_serverdb_command
use_user_command
Terms: Overview
Key Words: Overview