Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / August 2008

Tip: Looking for answers? Try searching our database.

informix developer tool

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
webjimmy - 25 Aug 2008 17:04 GMT
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
Obnoxio The Clown - 25 Aug 2008 17:18 GMT
> Hi friends,
>
[quoted text clipped - 3 lines]
> It seems that informix is difficute to code SQL statement.
>  

Real men use vi.

Gaylord.

Signature

Cheers,
Obnoxio the Clown

http://obotheclown.blogspot.com

david@smooth1.co.uk - 25 Aug 2008 22:27 GMT
> > Hi friends,
>
[quoted text clipped - 12 lines]
>
> http://obotheclown.blogspot.com

True, portable to almost all platforms and not as heavyweight as
emacs.
Fernando Nunes - 25 Aug 2008 23:01 GMT
Some generic tools work with Informix.
Besides those, you can consider for example:

. ServerStudio ( http://www.serverstudio.com )
. IBM Data Studio ( http://www-306.ibm.com/software/data/studio/ )

But you should specify exactly what you need to do.
If you're trying to look for Oracle equivalents you may hit a common error:
forgetting that databases are really different...
You probably don't need some of the "features" you find in some of the usual
tools for Oracle.

Regards.

> Hi friends,
>
[quoted text clipped - 11 lines]
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list

Signature

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

Bill Hamilton - 27 Aug 2008 03:31 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.