This is an old revision of the document!
Ispirer Home Page
Ispirer SQLWays Product Page
Request SQLWays
Sqlways.ini File - Section [TERADATA]
This article describes sqlways.ini file [TERADATA] section and the options it contains.
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 be different. |
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. |
USER | Specifies the user name 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. |
COMMENT_ORDER_BY | This option was added for Netezza to Teradata conversion. If it is Yes, then order by clause is commented in DML statements. If it is No or not specified, then order by clause is not commented in all the statements. Possible values Yes, No. The default is No. |
CONVERT_VOLATILE_INDEX | This option influences the way the indexes for GLOBAL TEMPORARY tables are converted to Teradata. If it is Yes, then indexes will be converted and added to CREATE VOLATILE TABLE statement. If it is No or not specified, then indexes will not be converted. Possible values Yes, No. The default 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 Yes, then indexes will be converted to PRIMARY INDEXES and added to CREATE VOLATILE TABLE statement. If it is No or not specified, then partition keys will be commented. Possible values Yes, No. The default is No. |
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 started started from which all the CHAR columns will be converted to VARCHAR. |
USE_FASTLOAD_UTILITY | This option allows to use fastload.exe utility to load the data into the Teradata database. Also for fastload utility should be specified such options like “FLOAD_ERRFILE”, “FLOAD_SESSIONS”, “FLOAD_TENACITY”, “FLOAD_SLEEP”, “FLOAD_ERRLIMIT”. Possible values - “Yes”, “No” or Empty. Default value - “No” or Empty. |
FLOAD_BIN | Specifies the directory where FLOAD utility is located. |
FLOAD_ERRFILE1 | Specifies the first error table where fastload utility will put information about the errors that occur during the fastload execution. The first error table record translation or constraint violation errors. |
FLOAD_ERRFILE2 | Specifies the second error table where fastload utility will put information about the errors that occur during the fastload execution. The second error table stores errors related to duplication of values for Unique Primary Index. |
FLOAD_SESSIONS | This option controls the number of sessions to establish with Teradata database. |
FLOAD_TENACITY | This option specifies the number of hours that fastload utility tries to establish the connection with the Teradata database. |
FLOAD_SLEEP | This option works together with “Tenacity” option. It controls the number of minutes to wait before fastload retry to establish the connection. |
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. |
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. |
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. |
Example:
[TERADATA] SERVER_NAME=servername DATABASE=test USER=dbc USE_CONVERT_CHAR_TO_VARCHAR=Yes CONVERT_CHAR_TO_VARCHAR=20
If you will have any question regarding the options and features supported for Teradata migration please feel free to mail our team: support@ispirer.com
Ispirer Home Page
Ispirer SQLWays Product Page
Request SQLWays