Number - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.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.