I am not new to SQL, but I don't know all the ins and outs of coding using Teradata's version of SQL. I have been able to read just enough to know that there is a way to set up input parameters using a macro, but I haven't been able to find a simple example of how it works.
So if I have this code:
SELECT Emp_Name FROM MyTable WHERE Emp_Number Between aram1Val and aram2Val ;
What is the proper way to set it up so that it will accept input instead of having to hardcode the values? All help greatly appreciated.
Thanks. Hey it was weird how my colon and P turned into graphics. Obviously there is some setting in this forum that converted it from an emoticon to graphics... whatever, ha ha.
Anyway, I have one follow up on this just to be sure that I know what you're talking about. When I create this macro, it's going to store it in the userdb (that's where I can put it). Will it stay there or do I need to recreate the macro every time?