User Defined Input

Tools & Utilities

User Defined Input

Oracle has a command that allows a user to input a variable and then that variable gets used in the SQL.

-----------
Example:
Select data
From table1
Where
TO_NUMBER(TO_CHAR(db1.table1.effective_dt,'YYYY')) in @variable('Enter Years (separated by a comma)') AND....
-----------------

When the query is run, a pop-up window appears asking the user which years he/she wants to look at.

Does Teradata have a similar function that reads input information and then uses that within the SQL?

Ultimately, I want to create an Excel model that is reading from a Teradata database and I want the users to input info into message boxes and have that input used in the SQL.