Option Syntax
|
Description
|
---|---|
-c dir
|
Change working directory
|
-C catalogname
|
Set the default catalog from where data is read from or written to
|
-e sql_string
|
Execute SQL string for export
|
-f filename
|
Execute SQL string from file for export
|
-l filename
|
Write log entries to this file
|
-L filename
|
Append log entries to this file
|
-m
|
In Unicode databases (General.InternalCharEncoding=UTF8), expect the data in character and wide character data type columns to be encoded in the console's locale/codepage, despite the settings in the server-side and client-side character data binding parameters.
In partial Unicode databases (General.InternalCharEncoding=Raw), expect the data in wide character data type columns to be encoded in the console's locale/codepage, despite the settings in the server-side and client-side character data binding parameters. Data in character data type columns is not converted.
|
-M locale_name
|
In Unicode databases (General.InternalCharEncoding=UTF8), expect the data in character and wide character data type columns to be encoded in the specified locale/codepage.
In partial Unicode databases (General.InternalCharEncoding=Raw), expect the data in wide character data type columns to be encoded in the specified locale/codepage. Data in character data type columns is not converted.
The format of locale_name depends on the operating system.
For example, in Linux environments, the locale name for the code page GB18030 in Chinese/China is zh_CN.gb18030.
In Windows environments, the locale name for Latin1 code page in Finnish/Finland is fin_fin.1252.
|
-o filename
|
Write exported data to this file
This option can be used only when exporting the data of a single table.
The default data and control file name is the same as the exported table name (<tablename>.dat and <tablename>.ctr).
|
-p
|
Preserve case of schema and table names
|
-s schema_name
|
Use only this schema for export
|
-S
|
Create SQL insert into clauses
|
-A
|
Add attribute names to insert clause
|
-u
|
In Unicode databases (General.InternalCharEncoding=UTF8), expect the data in character and wide character data type columns to be encoded in UTF-8.
In partial Unicode databases (General.InternalCharEncoding=Raw), expect the data in wide character data type columns to be encoded in UTF-8. Data in character data type columns is not converted.
|
-x pwdfile: filename
|
Read password from the file
|
-h, -?
|
Help = Usage
|