Between Symmetric (Aster Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
fcf1492702067123.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

This predicate is only available when connected to an Aster database.

The standard Between Symmetric comparison predicate is supported. It generates SQL of the form expression BETWEEN expression AND expression. The Between predicate evaluates to true if the first expression is greater than or equal to the second expression at the same time that it is less than or equal to the third expression. When dragging a Between operator into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Logical > Between Symmetric

Columns and/or other expressions can be moved into the (empty) branches of the tree, the first argument being the expression to the left of the BETWEEN, the second to the right, and the third to the right of the AND.