Re: SQuirreL and Informix

On Dec 14, 5:58 pm, "prich...@blm.gov" <prich...@blm.gov> wrote: > Thank you for answering so quickly. > > I tried "jumping" using the Catalog pull down, but I get the error: > > Error loading object type UDT Type. Error: java.sql.SQLException: > Another routine (mode_decode) with same signature already exists in > database.. See SQuirreL Logs for stackttrace. > > I looked at the SQuirreL log and can't decipher a cause. Let me suggest that IDS 9.4 comes with a license for basic level of AGS's Server Studio. That will allow you to administer much of the database level work you want to do and since it is purpose built for Informix it will show you all of your servers and all of the databases in each for you to pick though in the navigator window. Server Studio also provides an SQL editor/browser, a Stored Procedure debugger, database schema (DDL) development and diagramming, and many other features. You probably have Server Studio v5 installed already, but you can download Server Studio v6.1 (the latest) from AGS's web site and use the existing license file. You can also, if you decide you need to, license additional functionality and even the AGS Sentinel monitoring product which works with Server Studio to provide monitoring and alerts for your servers. Instead of using a generic product, check it out. Art S. Kagel