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. |