RE: informix developer tool

If you are on Windows, Winsql Lite is a good choice. It is free and saves you tons of time compared to dbaccess. You can have the results in a grid if you prefer, or generate html. I just use the text output myself. You will need to have the Informix odbc driver on the box you are running from. It will install a better odbc driver but that one times out in 30 days. They always try to get you go upgrade to the "Professional" version which draws ERP charts, etc. The error messages you get are not as specific as what you get from dbaccess, but if you know what you are doing, that is no problem. However, if you are writing a new stored proc, dbaccess is much more helpful. Winsql knows nothing about SPL and will just barf up some generic, unhelpful message. It also will not do "unload to x select ..." or "load from x insert into ..." . You have to use GO between statements unless you are in a transaction. That is a bit annoying. You can also select part of the screen and execute only that part, which is handy. The editor is dicey in my opinion and has unusual hot-keys. I wish it were more like the Visual Studio editor or even notepad. Or even better - vi . There are probably better products out there if you want to pay for them. > From: u45737@uwe.iiug.org> Subject: informix developer tool> Date: Mon, 25 Aug 2008 16:04:59 +0000> To: informix-list@iiug.org> > Hi friends,> > I am new person from Oracle. Does any developer tool for Informix SQL?> example oracle developer tool as SQL developer, Oracel SQL, TOAD.> > It seems that informix is difficute to code SQL statement.> > Thanks for any help> > Webjimmy> > _______________________________________________> Informix-list mailing list> Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list