Ispirer Ispirer
 

This is an old revision of the document!



Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Sqlways.ini File - Section [VERTICA_ANALYTIC_DATABASE]

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

Option name Description
TARGET_VERSION Specifies the target version for the Vetica database.
HOST Specifies a remote host name where the target Vetica database is located.
DATABASE Specifies the database name that is used in generated scripts for Vetica.
USER Specifies the user name that is used in generated scripts for Vetica.
PWD Specifies the user password that is used in generated scripts for Vetica.
PORT Specifies the database server port for Vetica.
BIN Specifies the directory where Vetica utilities are located.
CONVERT_MULTILINE_TO_SINGLELINE_COMMENT This option controls the way the multi-line comments are converted to Vetica. The default value is No.
DEFAULT_STORAGE This option controls the partitioning mechanism to use while converting to Vetica. 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.1540559229.txt.gz · Last modified: October 26, 2018, 01:07:09 PM by alexandr.kirpichny
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement