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.