Upper - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

The standard Upper case function is supported for converting all characters in an expression to upper case. It is valid only if the expression evaluates to a character data type. The SQL generated is UPPER (expression), and the type returned is that of the expression. When dragging an Upper operator into a variable, the following tree element is created

Variable Creation > Input > Variables: SQL Elements pane - String Functions > Upper

Columns and/or other expressions can be moved into the (empty) branches of the tree where the first argument is expression1 as indicated above, and the second expression2.

There are no special properties for the Upper operator.