|
From: Robert M. <rob...@gm...> - 2011-03-02 19:25:12
|
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 <joj...@ci... > 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:mda...@ja...] > *Sent:* 01 March 2011 23:49 > *To:* Thomas, Jojo John [CCC-OT_IT] > *Cc:* 'squ...@li...' > *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 - joj...@ci...) > > 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 > Squ...@li... > 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 > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
