Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:command-line:sqlways-ini:data-section [October 12, 2018, 08:17:14 AM]
darya.prikhodkina
sqlways:command-line:sqlways-ini:data-section [October 31, 2018, 03:11:47 PM] (current)
alexandr.kirpichny
Line 33: Line 33:
 | **COLUMN_NAMES_FIRST_ROW** | The option controls if columns names should be add before data in the first row of data file. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No". | | **COLUMN_NAMES_FIRST_ROW** | The option controls if columns names should be add before data in the first row of data file. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No". |
 | **COBOLFORMAT** | The option defines the format of cobol code as a source direction. If this option is set to "No" - parser technology will exclude from analysis first 6 characters and all the characters that follow the 74th character in a row. If this option is set to "Free" - parser will try to read the cobol code as is, without removing any characters. If this option is set to "ANSI" - parser technology will not read all the characters that follow the 74th character in a row. \\ Possible values - "No", "Free", "ANSI". \\ Default value - "ANSI". | | **COBOLFORMAT** | The option defines the format of cobol code as a source direction. If this option is set to "No" - parser technology will exclude from analysis first 6 characters and all the characters that follow the 74th character in a row. If this option is set to "Free" - parser will try to read the cobol code as is, without removing any characters. If this option is set to "ANSI" - parser technology will not read all the characters that follow the 74th character in a row. \\ Possible values - "No", "Free", "ANSI". \\ Default value - "ANSI". |
 +| **CONVERT_EMPTY_STRINGS_TO_NULL** | If this option is set to "Yes", then empty strings in default values for character columns will be converted to NULLs. When target database is Oracle, need to leave empty strings as is, as in Oracle it is equal to NULL value. If this options is set to "No", default values will be left as is. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No". | 
 +| **UUID_CONVERSION** | This option controls the case of the characters in the GUID columns. \\ Possible values - "LOWER", "UPPER". \\ Default value - "LOWER". | 
 +| **DB2_APP_CTL_HEAP_SZ** | This option set the APP_CTL_HEAP_SZ parameter in DB2 database when running the export of data from DB2. In this option we need to specify the number of KBs. | 
 +| **DATE_TIME_DATA_CONCAT_MAPPING** | In this option you specify the path to the txt file with the date and time mapping. | 
 +| **IBMRPG_VERSION** | This option defines version of RPG formatting. For more information about the specifics of the RPG formatting, please contact our support team:[[[email protected]]]. \\ Possible values - "ILE", "400". \\ Default value - "ILE".  | 
 +| **SKIP_EXPORT_IF_DATAFILES_EXIST** | If this option is set to "Yes", SQLWays will check whether the .txt file with the data and with the same name as table that is specified for conversion, exists in the export directory, then the tool will skip the data extraction for that table. If there is no .txt file with the same name as table name, then the tool will extract the data for that table. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No".  | 
 +| **COBOL_TAB_WIDTH** | This option removes the TAB character with the appropriate number of spaces, that should be defined in this option. \\ Default value - 4.  | 
 +| **DECIMALPOINT** | This option defines the decimal point that should be used by SQLWays tool for numeric data types. | 
 +| **REVERSE_BLOCK_NAMES** | If this option is set to "Yes", block names that starts with numbers will be changed and numbers will be placed at the end of the block names. If this option is set to "No" - names will be left as is. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | 
 +| **COMP_FORMATTING** | This option defines the way of conversion of COMP clause for items. If it is set to "Yes" COMP clause will be converted. If it is set to "No" - COMP clause will be removed from conversion when migrating from Cobol to Oracle. \\ Possible values - "No","Yes" or Empty. \\ Default value - "Yes" or Empty. |
  
  
sqlways/command-line/sqlways-ini/data-section.1539332234.txt.gz · Last modified: October 12, 2018, 08:17:14 AM by darya.prikhodkina
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement