5.4.5 - Parameter Data Types - Teradata Warehouse Miner

Teradata Warehouse Miner Model Manager User Guide

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
November 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
uxf1503087323034.ditamap
dita:ditavalPath
ft:empty
ADS parameters can be any one of the six data types. Their values are substituted into the SQL commands prior to executing the ADS portion of a model.
Type Description
STRING Any string literal.
NUMBER

Any number in integer, decimal, or E notation in locale specific format.

For example:

123 -123 123.456 1.123456E20 -1.123456E-10

Note that the mantissa in E notation format can only have one digit to the left of the decimal point and up to six digits to the right of the decimal point. The positive sign in the exponent is omitted. An exponent can have up to three digits.

DATE

A date literal in locale specific format.

For example:

12/31/2000 31/12/2000 31-12-2000 (based on locale)

TIME

A time literal in locale specific format.

For example:

3:30 PM 15:30 (based on locale)

TIMESTAMP A timestamp literal in locale specific format. This is usually the date literal concatenated with the time literal.
SQLTEXT Any string literal that will be substituted into the SQL commands as-is, without enclosing within a pair of quotes.