Differences

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

Link to this comparison view

guides:migration-toolkit:command-line:sqlways-ini:teradata-section [2019/06/11 00:26]
127.0.0.1 external edit
guides:migration-toolkit:command-line:sqlways-ini:teradata-section [2019/11/16 11:51] (current)
darya.prikhodkina
Line 1: Line 1:
 ====== Sqlways.ini File - Section [TERADATA] ====== ====== Sqlways.ini File - Section [TERADATA] ======
  
-This article describes sqlways.ini file [TERADATA] section and the options it contains. ​+This article describes sqlways.ini file'​s ​[TERADATA] section and the options it contains. ​
 ^  Option name  ^ Description ​ ^  ^  Option name  ^ Description ​ ^ 
-| **TARGET_VERSION** | Specifies the target version of the Teradata database. If this option is empty the latest Teradata database version will be used. Note: According to the version number conversion results may differ. ​ |+| **TARGET_VERSION** | Specifies the target version of Teradata database. If this option is empty the latest Teradata database version will be used. Note: According to the version number conversion results may differ. ​ |
 | **SERVER_NAME** | Specifies the server name which is used in generated scripts for the BTEQ utility. ​ | | **SERVER_NAME** | Specifies the server name which is used in generated scripts for the BTEQ utility. ​ |
 | **DATABASE** | Specifies the database name which is used in generated scripts for Teradata. ​  | | **DATABASE** | Specifies the database name which is used in generated scripts for Teradata. ​  |
Line 9: Line 9:
 | **PWD** | Specifies the user password which is used in generated scripts for Teradata. ​ | | **PWD** | Specifies the user password which is used in generated scripts for Teradata. ​ |
 | **BIN** | Specifies the directory where BTEQ utility is located. ​  | | **BIN** | Specifies the directory where BTEQ utility is located. ​  |
-| **COMMENT_ORDER_BY** | This option was added for Netezza to Teradata conversion. If it is set to Yes, order by clause will be commented in DML statements. If it is No or not specified, order by clause will not be commented in all the statements. Possible values Yes, No. The default value is No.  | +| **COMMENT_ORDER_BY** | This option was added for Netezza to Teradata conversion. If it is set to "Yes", order by clause will be commented in DML statements. If it is "No" ​or not specified, order by clause will not be commented in all the statements. Possible values ​are "Yes""No". The default value is "No".  | 
-| **CONVERT_VOLATILE_INDEX** | This option influences the way the indexes for GLOBAL TEMPORARY tables are converted to Teradata. If it is set to Yes, indexes will be converted and added to CREATE VOLATILE TABLE statement. If it is No or not specified, indexes will not be converted. Possible values Yes, No. The default value is No.  | +| **CONVERT_VOLATILE_INDEX** | This option influences the way the indexes for GLOBAL TEMPORARY tables are converted to Teradata. If it is set to "Yes", indexes will be converted and added to CREATE VOLATILE TABLE statement. If it is "No" ​or not specified, indexes will not be converted. Possible values ​are "Yes""No". The default value is "No".  | 
-| **PARTIT_KEY_TO_PRIMARY_IDX** | This option influences the way the partition keys for GLOBAL TEMPORARY tables are converted to Teradata. If it is set to Yes, indexes will be converted to PRIMARY INDEXES and added to CREATE VOLATILE TABLE statement. If it is No or not specified, partition keys will be commented. Possible values Yes, No. The default value is No.  |+| **PARTIT_KEY_TO_PRIMARY_IDX** | This option influences the way the partition keys for GLOBAL TEMPORARY tables are converted to Teradata. If it is set to "Yes", indexes will be converted to PRIMARY INDEXES and added to CREATE VOLATILE TABLE statement. If it is "No" ​or not specified, partition keys will be commented. Possible values ​"Yes""No". The default value is "No".  |
 | **USE_CONVERT_CHAR_TO_VARCHAR** | Specifies whether the CHAR datatype will be converted to VARCHAR when migrating to Teradata. ​ | | **USE_CONVERT_CHAR_TO_VARCHAR** | Specifies whether the CHAR datatype will be converted to VARCHAR when migrating to Teradata. ​ |
 | **CONVERT_CHAR_TO_VARCHAR** | This option works together with USE_CONVERT_CHAR_TO_VARCHAR and defines the length of CHAR columns starting from which all the CHAR columns will be converted to VARCHAR. ​ | | **CONVERT_CHAR_TO_VARCHAR** | This option works together with USE_CONVERT_CHAR_TO_VARCHAR and defines the length of CHAR columns starting from which all the CHAR columns will be converted to VARCHAR. ​ |
Line 23: Line 23:
 | **FLOAD_ERRLIMIT** | This option specifies maximum number of rejected errors that fastload utility will put in the first error table. | | **FLOAD_ERRLIMIT** | This option specifies maximum number of rejected errors that fastload utility will put in the first error table. |
 | **USE_BLOCK_LEVEL_COMPRESSION** | This option defines whether the block level compression will be used when making import into Teradata database using FastLoad. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default values - "​No"​ or Empty. | | **USE_BLOCK_LEVEL_COMPRESSION** | This option defines whether the block level compression will be used when making import into Teradata database using FastLoad. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default values - "​No"​ or Empty. |
-| **LOGGING_MECHANISM** | This option defines logging mechanism that will be used co connect to the Teradata database. \\ Possible values - "​LDAP","​NTLM",​ "​Default"​ or Empty. \\ Default value - "​Default"​ or Empty. |+| **LOGGING_MECHANISM** | This option defines logging mechanism that will be used to connect to Teradata database. \\ Possible values - "​LDAP","​NTLM",​ "​Default"​ or Empty. \\ Default value - "​Default"​ or Empty. |
 | **CHECKPOINT** | This option defines CHECKPOINT option for FASTLOAD utility. \\ Default value - Empty. | | **CHECKPOINT** | This option defines CHECKPOINT option for FASTLOAD utility. \\ Default value - Empty. |
 | **QUERYBAND** | This option adds SET QUERY_BAND option for the current session or transaction in the generated FLD file. \\ Default value - Empty. | | **QUERYBAND** | This option adds SET QUERY_BAND option for the current session or transaction in the generated FLD file. \\ Default value - Empty. |