Masking commas within a macro parameter

Scott — Thu, 29 Mar 2007 21:47:05 GMT

Hi,

I was wondering if anyone knows a simple way of masking a comma within a given macro parameter so that Teradata doesn't interpret the parameter as multiple parameters.

eg:
CREATE MACRO test(prodno) AS
(
SELECT *
FROM products
WHERE product_code IN (:prodno)
;
);

EXEC test(12, 13);

The number of products could be one or more (ie a variable number).

Obviously the macro and execution, as is, produces an error as Teradata is only expecting one parameter, but sees two.

Is there a simple way around this?

Thanks in advance for your help.

Cheers,
Scott.

Teradata Forums / Teradata / Teradata Advanced Analytics User Group / Masking commas within a macro parameter / Latest Posts

Masking commas within a macro parameter