Toad World® Forums

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

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?

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 3.8.0.128. Please download and try