Ispirer Ispirer
 


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
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.


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/command-line/sqlways-ini/teradata-section.txt · Last modified: August 26, 2015, 01:50:58 AM by ekaterina.barsuk
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement