Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Sqlways.ini File - Section [VERTICA_ANALYTIC_DATABASE]

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

Option name Description
TARGET_VERSION Specifies a target version of Vertica database.
HOST Specifies a remote host name where the target Vertica database is located.
DATABASE Specifies a database name that is used in generated scripts for Vertica.
USER Specifies a user name that is used in generated scripts for Vertica.
PWD Specifies a user password that is used in generated scripts for Vertica.
PORT Specifies a database server port for Vertica.
BIN Specifies the directory where Vertica utilities are located.
CONVERT_MULTILINE_TO_SINGLELINE_COMMENT This option controls the way the multi-line comments are converted to Vertica. The default value is No.
DEFAULT_STORAGE This option controls the partitioning mechanism to use while converting to Vertica. The default value is HASH_PARTITION_BY, which means that HASH PARTITION is used by default.

Example:

[VERTICA_ANALYTIC_DATABASE]
HOST=hostname
DATABASE=test
USER=tester


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/command-line/sqlways-ini/vertica-section.txt · Last modified: March 29, 2019, 11:50:15 AM by darya.prikhodkina
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement