The plugin documentation says:
 
"The source tab for stored procedures displays the source for the selected stored procedure and can be accessed by navigating to the "PROCEDURE" folder in the object tree" (http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/plugins/netezza/src/main/resources/doc/readme.html?revision=5818)
 
If you need to edit a stored procedure, you can copy the source and paste it in the SQL editor.
 
I am not familiar with the "Netezza Workbench", but while SQuirreL is a very capable database client, it's strength is its consistent capability across a wide range of databases, versus a tool geared for one database at the expense of all others.  So it is very possible that a tool that focuses on Netezza or any other database in particular may have more features that are specific to that database.
 
Rob

On Wed, Mar 2, 2011 at 7:33 AM, Thomas, Jojo John <jojo.john.thomas@citi.com> wrote:

Hi Matt,

Thank you very much. Was able to get working with Netezza – using Extra Class Path TAB (now changed as per your suggestion).

Does the SQuirrel SQL client also allow editing of procedures, or just view – (that is what the plug-in documentation suggests)

 

Also, would you, or anybody else on the forum be able to advice if <<Aginity - Netezza Workbench>> is better when working with Netezza.

Cheers, Jojo

+44 79 0381 5270

 

From: Matt Dahlman [mailto:mdahlman@jaspersoft.com]
Sent: 01 March 2011 23:49
To: Thomas, Jojo John [CCC-OT_IT]
Cc: 'squirrel-sql-users@lists.sourceforge.net'
Subject: Re: [Squirrel-sql-users] Squirrel with Netezza

 

Hello,
 
The SQuirreL installer doesn't ship JDBC drivers.  You should download the Netezza jdbc driver and copy it into the SQUIRREL_INSTALL_DIR/lib folder, then restart SQuirreL.
 
In case you're wondering about the optional Netezza plugin, it extends SQuirreL to enhance it's capabilities when working with a Netezza database.

Matt

(With apologies to Rob, since I just did s/MySQL/Netezza/ on his last email!)

 

On 1 Mar 2011, at 4:54, Thomas, Jojo John wrote:



Hi,

 

Need help with configuring Squirrel with Netezza.

Have installed Netezza plugin, but Netezza does not appear under drivers.

 

Cheers,

Jojo (jt22629 - jojo.john.thomas@citi.com)

Working from UK/London/CGC1

W. +44 20 7986 7347 M. +44 79 0381 5270

 

 

 

------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev _______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

 


------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users