 |
 |
Archives of the TeradataForum
Message Posted: Fri, 06 Aug 2004 @ 08:56:55 GMT
| Subj: | | Re: Using a parameter in a macro |
| |
| From: | | Julie.Flanagan |
| | Now I've to write a generic query that will query this table and pull records based on conditions only on AGE column like '> 12' or
'< 30' or '<=15' etc | |
| | I'm going to get this condition as parameter in macro and I need to plug it in my where clause and the correct condition should be
interpreted 'AGE >12 ' or 'AGE < 30' | |
To create Macro:
Replace Databasename.MacroNew As
(Select * from Table
where
Age > :MinAge and Age < :MaxAge)
To execute this, put the 2 values you wish to pass in for MinAge and MaxAge in brackets after the macro name, e.g.:
Exec Databasename.MacroNew (12, 30) (For between 12 and 30)
Exec Databasename.MacroNew (0, 15) (For <= 15), etc.
| |
