|
Archives of the TeradataForumMessage Posted: Mon, 28 Aug 2000 @ 10:06:41 GMT
I am looking for a way to specify multiple integer options in one macro parameter. e.g. on the following table I need to select multiple regions and multiple store_no's Stores table: Index is region,store_no Create macro read_stores as (:reg varchar(30) ) Works for the region code, which is character - exec read_stores('A B C'); How can I achieve the same result on the store_no field? Store numbers range from 1 to 30. The following works, but there must be a better/more efficient solution: sel * To allow for the 'all regions' options, I have set the macro as follows: Create macro read_stores as (:reg varchar(30), rlim byteint ) Where rlim is 0, the region must exist in the list Where rlim is -1, any region code will match, so all regions are selected. Is there another way of achieving the same result without having a separate macro for each case? The final macro will run against large tables, with a number of these multi-selection parameters. Any examples, advice or comments are welcome. Thanks Barbara George You can't get ahead if you're trying to get even
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||