Not getting the error message from Teradata Macro ( using ABORT option )

Database

Not getting the error message from Teradata Macro ( using ABORT option )

Hi,

I am trying to pop-up a message by using ABORT option in Teradata Macro ( using Teradata 13 ) like this:

CREATE MACRO devdb.macro_test ( my_param integer ) as (

ABORT 'pls input my_param between 1 and 100' WHERE :my_param <1 or :my_param >100;

);

EXEC devdb.macro_test ( 110 );

When I execute the macro, it is executing & the message is "EXECUTE completed. 0 rows processed" but the error message is not appearing in the teradata sql assistant.

Please let me know if there is any special setting to pop-up the message.