We instrument our stored procedures with RAISE NOTICE statements, in what I think is a pretty standard approach to Netēzza Development.
However, Toad Data Point does not seem to support it at all. If I execute
CREATE OR REPLACE PROCEDURE TESTRAISENOTICE() RETURNS DATE LANGUAGE NZPLSQL AS
RAISE NOTICE ‘Towards thee I roll, thou all-destroying but unconquering whale’;
RAISE NOTICE ‘to the last I grapple with thee’;
RAISE NOTICE ‘from hell’‘s heart I stab at thee’;
RAISE NOTICE ‘for hate’‘s sake I spit my last breath at thee’;
DROP PROCEDURE TESTRAISENOTICE();
I don’t see even the first notice! I just get a bland ‘Executed Successfully.’ Where’s my Moby Dick?
The Netezza proider in Toad Data Point is supported by ODBC and does not support notifications. This type of support is done when we code a native provider. To do this Netezza needs to offer a ado.net connector which it doesn’t.
This is the output in Aginity Workbench
NOTICE: Towards thee I roll, thou all-destroying but unconquering whale
NOTICE: to the last I grapple with thee
NOTICE: from hell’s heart I stab at thee
NOTICE: for hate’s sake I spit my last breath at thee
/ Start time 6/12/2015 3:47:22 PM, end time 6/12/2015 3:47:22 PM. /
/ Duration 0.148 sec. /
/ Records Affected: 1. */
We discussed this and I have entered QAT-5935/5906 for this enhancement.
We have added support for info messaging. This fix is available in today’s Beta. TDP 188.8.131.52. Please download and try