About Ispirer Systems

Ispirer Home Page Database Migration Application Conversion Downloads


Sqlways.ini File - Section [TERADATA]

This article describes sqlways.ini file's [TERADATA] section and the options it contains.

Option name Description
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.
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 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 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”.
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.
USE_FASTLOAD_UTILITY This option allows to use fastload.exe utility to load the data into the Teradata database. Such options as “FLOAD_ERRFILE”, “FLOAD_SESSIONS”, “FLOAD_TENACITY”, “FLOAD_SLEEP”, “FLOAD_ERRLIMIT” should also be specified for fastload utility.
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 occurred during the fastload execution. The first error table records translation or constraint violation errors.
FLOAD_ERRFILE2 Specifies the second error table where fastload utility will put information about the errors that occurred 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 will 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 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.
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 have any question regarding the options and features supported for Teradata migration please feel free to mail our team: support@ispirer.com