RAISE NOTICE -- how do I see the notices in Toad Data Point?

Toad Data Point
1

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

BEGIN_PROC

BEGIN

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’;

RETURN ‘25APR1968’;

END;

END_PROC;

EXECUTE TESTRAISENOTICE();

DROP PROCEDURE TESTRAISENOTICE();

I don’t see even the first notice! I just get a bland ‘Executed Successfully.’ Where’s my Moby Dick?

2

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.

3

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. */

4

We discussed this and I have entered QAT-5935/5906 for this enhancement.

5

We have added support for info messaging. This fix is available in today’s Beta. TDP 3.8.0.128. Please download and try