Uppercase Characters are Passed as Lowercase if not Escape Quoted - 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

If your data contains a table or schema with a capital letter in its name, you must escape quote the table or schema name. If you do not do this, all lower case letters are assumed. Because of this, the data will load into a schema or table having the same name all in lower case, if it exists.

For example, if you specify the table Test.Try, Test.try, test.Try or test.try, the data will always be loaded into test.try unless you specify escape characters with enclosed quotes for the table name parameter to ncluster_loader as in this example:

# /home/beehive/clients/ncluster_loader -U db_superuser -w db_superuser -c '\"Test\".\"Try\"' file001
Loading tuples using node 'localhost'.
4 tuples were successfully loaded into table '"Test"."Try"'.

This example loads the data in the expected table (Test.Try).