Number - 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

Numeric literals may be entered in integer, decimal or scientific notation formats. When dragging a literal Number into a variable, the following tree element is created:

Variable Creation > Input > Variables: SQL Elements pane - Literals > Number

A default value of an integer 0 is provided, but can be changed via Properties. Double-click on Number (0) or highlight and click on the Properties button:

Variable Creation > Input > Variables: SQL Elements pane - Literals > Number Properties

An integer, decimal or floating point literal value in scientific notation will be generated as necessary.