Not Between - 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

The standard NOT BETWEEN comparison predicate is supported. It generates SQL of the form or expression NOT BETWEEN expression AND expression. The Not Between predicate is the logical opposite of the BETWEEN predicate. It tests that the first expression is less than the second expression, or greater than the third expression. When dragging a Not Between operator into a variable, the following tree element is created.

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

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.

There are no special properties for the Not Between operator.