Database Studio Preferences: Export/Import

Use

Property	Options	Comments and Further Information
Connection Parameters for Export/Import	Auto Commit Mode SQL Mode Isolation Level	Connection parameters that the system uses to execute SQL statements during export/import: AUTOCOMMIT mode SQL mode Isolation level
Export/Import Directory for Catalog and Data	Use Loader Packages Use Files	Choose whether you want to use Loader packages or files for the export/import and specify the path where they are to be stored.

Property

Options

Comments and Further Information

Connection Parameters for Export/Import

Connection parameters that the system uses to execute SQL statements during export/import:

Export/Import Directory for Catalog and Data

Use Loader Packages

Use Files

Choose whether you want to use Loader packages or files for the export/import and specify the path where they are to be stored.

Property	Options	Comments and Further Information
Data File Formats	File Format	Loader, CSV, FWV, FWV BINARY PAGES, RECORDS
LOB Files	Loader, Exporting and Importing LOB Values
Data Field Formats	Text Fields	Loader, Data Format
Data/Time Formats
Representation of special values
Number value format
Error Handling	Primary key constraint	Defines how duplicated data records are dealt with on import
Maximum allowed errors for a single command	Determines how many errors must occur before the export/import process is aborted