Number of lines limit in a Macro

Tools
Enthusiast

Number of lines limit in a Macro

I heard there was a 30 lines limit in a Macro for performance sake.
If I have a very long select statement that spans over 50 lines, I can't use a stored procedure (I'm using Teradata V2R6.2) so I will have to use a Macro. What is the consequence of it?

Thank you.
Regards, Nancy
1 REPLY
Senior Apprentice

Re: Number of lines limit in a Macro

Hi Nancy,
where did you hear about that limit?
The performance of a macro is the same as the performance of the base statements.

The only limit should be the 1MB source code limit.

Dieter