5.4.5 - Parameter Data Types - Teradata Warehouse Miner

Teradata Warehouse Miner Model Manager User Guide

prodname
Teradata Warehouse Miner
vrm_release
5.4.5
created_date
November 2017
category
User Guide
featnum
B035-2303-117K
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.