|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/8/2006 1:25:00 PM
Posts: 2,
Visits: 1
|
|
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.
-Rob
|
|
|
|