Using the -C Option With Uppercase or Special Characters - Aster Client

Teradata Aster® Client Guide

Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software

When using the -C option where the column list has any uppercase or special characters, you must put the column list in double quotes. On Windows, this requires escaping the double quotes:

Example on Linux:

./ncluster_loader -h 10.51.150.100 -l 10.51.150.240 -w db_superuser -U db_superuser -c -D , -C '"ID","NAME","$value"' test2 test2.csv

On Windows, when using the -C option where the column list has any uppercase or special characters, you must put the column list in escaped double quotes.

Example on Windows:

ncluster_loader.exe -h 10.51.150.100 -w db_superuser -U db_superuser -c -C '\"ID\",\"NAME\",\"$value\"' test2 test2.csv