Case-Sensitive Handling for Table Names - 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

To force Aster Loader to treat your table and schema names in a case-sensitive manner, you must surround the schema and table names in double quote marks when you invoke ncluster_loader. To pass a double quote mark to Aster Loader, you must prefix it with the escape character, which is a backslash. That means you type a double quote mark like so:\". If either the schema name, the table name or both names include capital letters, you must surround each name in escaped quotation marks, individually.

For example, assuming you want to load to table "Bar" in schema "Foo", then you would invoke Aster Loader using this form:

ncluster_loader.exe -h 10.51.3.100 -U mjones -w st4g0l33 \"Foo\".\"Bar\" mydata.csv -c

and in the map file, you would reference the table as:

"table" : "\"Foo\".\"Bar\"",

If you want to load to table "bar" in schema "Foo", you would still need to escape quote the schema and the table separately as follows:

ncluster_loader.exe -h 10.51.3.100 -U mjones -w st4g0l33 \"Foo\".\"bar\" mydata.csv -c

and in the map file, as:

"table" : "\"Foo\".\"bar\"",