Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

DDL and Data Options - Data Options/Files Combobox

Overview

Option name Description
Default for the target Controls output text format
Column delimiter Specifies column delimiter for files with data
Blanks count Specifies the number of blanks between columns for FIX output format
Commit count Controls number of rows for COMMIT during data insert
Line delimiter Specifies line delimiter for files with data
Replace newline Specifies a character string that replaces newline characters in the data
Remove newline Controls whether newline characters should be removed or no
Resolve delimiter conflicts Controls if resolving delimiter conflicts should be done during data export
Output column names in the first row of data file Controls if columns names should be add before data in the first row of data file

Choose “Tables” in the tree on the left, “Data Options” tab, “Files” combobox.

Default for the target

The option controls output text format in which data will be extracted from source database for further importing into target database. Below output text formats are allowed. * Column delimited (CSV) * Fixed length: * TAB delimited * INSERT statements * XML * Btrieve data file * PC/IXF

The tool identifies more suitable out text format for specific target DBMS. For most databases data is extracted into *.TXT files.

Column delimiter

The option controls column delimiter in files with data. By default comma ”,” delimiter is used.

Blanks count

This option specifies the number of blanks that are placed between columns for FIX (fixed length) output format. The default value is 1.

Commit count

This option is only valid for INS (INSERT statements) output format and is used to generate a COMMIT statement after the specified number of INSERT statements is generated. The default value is 0 (no commits are generated).

Line delimiter

The option specifies line delimiter for files with data. By default carriage return (CR) is used.

Replace newline

Specifies a character string that replaces newline characters in the data. Newline characters are 0x0D0A or \r\n for Windows and 0x0A or \n for Unix. Character columns like CHAR and VARCHAR e.g. can contain newline characters in the data. By default, SQLWays saves them in the export files. Using this option you can specify a string that will replace newline characters. For example, to replace newlines with zzz, set REPLACE_NEWLINE=zzz, to replace newlines with a blank, set REPLACE_NEWLINE=” ”. To specify the hexadecimal value of a character use the following syntax: 0xhh. For example, 0x2c specifies a comma character. Non printing characters like tab, carriage return and new line can be represented by \t, \r and \n accordingly. To specify a backslash character use '\\'. You can combine different character representations to specify the string. For example, REPLACE_NEWLINE=¦¦¦0x2c0x2c¦¦¦ When you need to remove newlines from the data, use the REMOVE_NEWLINE option. The REPLACE_NEWLINE option is ignored when the REMOVE_NEWLINE option is set to Yes (see below). In most cases, when you need to save newline characters in the data you have to change the line delimiter using the /LDEL option. This makes possible properly processing rows by import/load utilities.

Remove newline

The option controls whether newline characters should be removed or no. If “Yes” is specified, newline characters are removed from the data. Newline characters are 0x0D0A or \r\n for Windows and 0x0A or \n for Unix. Character columns like CHAR and VARCHAR e.g. can contain newline characters in the data. By default, SQLWays saves them in the export files. Using this option, you can specify that newline characters be removed from the data. The default is No. Possible values - “Yes”, “No”. If you need to replace newline characters with another string, use the REPLACE_NEWLINE option (see earlier). In most cases, when you need to save newline characters in the data, you have to change the line delimiter using the /LDEL option. This makes possible properly processing rows by import/load utilities.

Resolve delimiter conflicts

This option controls if resolving delimiter conflicts should be done during data export. It is helpful when source data contains the same symbols as used as delimiter. If delimiter conflicts are not resolved, target database will not be able to import data correctly. If resolving delimiter conflicts option is set into “Yes”, additional files with conflict data are created. In these files specific delimiters are used to demarcate each row and each column. By default “Yes” value is used.

Output column names in the first row of data file

The option controls if columns names should be add before data in the first row of data file. By default “No” value is used.


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

sqlways/users-guide/wizard/specify-ddl-data/table_options/data_options/files.txt · Last modified: May 07, 2018, 03:15:36 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement