informix developer tool

On Aug 25, 3:42 pm, "Art Kagel" wrote:
> Develoment tools for Informix:
>

> Informix 4GL
> Perl DBI
> ESQL/C
> ODBC
> JDBC

These are not tools...

I-4GL - Language. (Unless you're talking about RDS)
Perl-DBI - Perl Module
ESQL/C - Language
ODBC - API interface
JDBC - API interface

I agree that there are tools out there. SquirrelDB is another one.

As others had mentioned : AGS ServerStudio has a host of tooling around
Informix
IBM Data Studio :
http://www.ibm.com/developerworks/do...AGX01&S_CMP=LP
Others:
DB2 Web Query Tool - also supports Informix
http://www-01.ibm.com/software/data/...2tools/db2wqt/
the OpenAdminTool - has configuration/monitoring as well as a query
interface (you will need IDS 11)
Download at :
https://www14.software.ibm.com/webap...wg-informixfpd

On Mon, Aug 25, 2008 at 8:00 PM, Ian Michael Gumby wrote:

> On Aug 25, 3:42 pm, "Art Kagel" wrote:
> > Develoment tools for Informix:
> >
>
> > Informix 4GL
> > Perl DBI
> > ESQL/C
> > ODBC
> > JDBC
>
> These are not tools...
>
> I-4GL - Language. (Unless you're talking about RDS)
> Perl-DBI - Perl Module
> ESQL/C - Language
> ODBC - API interface
> JDBC - API interface
>
> I agree that there are tools out there. SquirrelDB is another one.
> _______________________________________________
> Informix-list mailing list
> Informix-list-at-iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>

On Mon, Aug 25, 2008 at 11:22 PM, Rajesh Nair wrote:

>
> On Mon, Aug 25, 2008 at 8:00 PM, Ian Michael Gumby wrote:
>
>> On Aug 25, 3:42 pm, "Art Kagel" wrote:
>> > Develoment tools for Informix:
>> >
>>
>> > Informix 4GL
>> > Perl DBI
>> > ESQL/C
>> > ODBC
>> > JDBC
>>
>> These are not tools...
>
>
Sorry fellow trench trudger, but those are the tools of my trade, at least
some of them. Tools are in the eye of the beholder.

The OP mentions TOAD and editing SQL, but is that ALL he wants to
accomplish? I dunno, so I listed many tools of different capabilities and
uses.

If the guy had said: "Using a manual hammer is SO tiring, plebian, and
boring aren't there other tools I can use to work with wood? Steel has
welders I can use?" Would you have stopped at mentioning stable and nail
guns and Elmer's Carpenter's Glue? Or would you also mention saws and
rulers, and levels, and ... You get the point (I hope). Oh, and no snide
matching of materials chosen for the analogy to RDBMS products from the
lurkers and trolls out there.

Art



>>
>> I-4GL - Language. (Unless you're talking about RDS)
>> Perl-DBI - Perl Module
>> ESQL/C - Language
>> ODBC - API interface
>> JDBC - API interface
>>
>> I agree that there are tools out there. SquirrelDB is another one.
>> _______________________________________________
>> Informix-list mailing list
>> Informix-list-at-iiug.org
>> http://www.iiug.org/mailman/listinfo/informix-list
>>
>
>
> _______________________________________________
> Informix-list mailing list
> Informix-list-at-iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>


--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art-at-iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.

Sorry Art,
You may call them Tools of the trade.

But nomenclature is important when you need to communicate an idea or concept.

I'm now having to reverse a script I wrote for production because I did what they said they wanted, not what they really wanted. And of course, itwas a rush job so there wasn't really time to get in to their head and youhad to trust that they knew what they were saying....

Yet I digress.

The point is that these are not tools but 'standard' APIs and Languages.

Its great that you know them, but when someone asks about tools, they want the IDEs and environments that let you get your work done.

-G
PS. I wasn't the only one who missed the 'red flags'. I'm just the guy who has to fix it. ;-)
God I am starting to hate unicode.


Date: Tue, 26 Aug 2008 00:24:57 -0400
From: art.kagel-at-gmail.com
To: informix-list-at-iiug.org
Subject: Re: Fwd: informix developer tool

On Mon, Aug 25, 2008 at 11:22 PM, Rajesh Nair wrote:


On Mon, Aug 25, 2008 at 8:00 PM, Ian Michael Gumby wrote:


On Aug 25, 3:42 pm, "Art Kagel" wrote:

> Develoment tools for Informix:

>



> Informix 4GL

> Perl DBI

> ESQL/C

> ODBC

> JDBC



These are not tools...
Sorry fellow trench trudger, but those are the tools of my trade, at least some of them. Tools are in the eye of the beholder.

The OP mentions TOAD and editing SQL, but is that ALL he wants to accomplish? I dunno, so I listed many tools of different capabilities and uses.


If the guy had said: "Using a manual hammer is SO tiring, plebian, and boring aren't there other tools I can use to work with wood? Steel has welders I can use?" Would you have stopped at mentioning stable and nail gunsand Elmer's Carpenter's Glue? Or would you also mention saws and rulers, and levels, and ... You get the point (I hope). Oh, and no snidematching of materials chosen for the analogy to RDBMS products from the lurkers and trolls out there.


Art







I-4GL - Language. (Unless you're talking about RDS)

Perl-DBI - Perl Module

ESQL/C - Language

ODBC - API interface

JDBC - API interface



I agree that there are tools out there. SquirrelDB is another one.

_______________________________________________

Informix-list mailing list

Informix-list-at-iiug.org

http://www.iiug.org/mailman/listinfo/informix-list




_______________________________________________

Informix-list mailing list

Informix-list-at-iiug.org

http://www.iiug.org/mailman/listinfo/informix-list




--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art-at-iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.





__________________________________________________ _______________
See what people are saying about Windows Live. Check out featured posts.
http://www.windowslive.com/connect?o...onnect2_082008

Ian Michael Gumby wrote:
> Sorry Art,
> You may call them Tools of the trade.
>
> But nomenclature is important when you need to communicate an idea or
> concept.
Or: "since I don't have anything useful to say, I'll use arbitrary
pedantry in a desperate attempt to win an argument." I get this from my
12-year-old daughter all the time.

>
> I'm now having to reverse a script I wrote for production because I
> did what they said they wanted, not what they really wanted. And of
> course, it was a rush job so there wasn't really time to get in to
> their head and you had to trust that they knew what they were saying....
>
> Yet I digress.
>
There's a first.

> The point is that these are not tools but 'standard' APIs and Languages.
>
> Its great that you know them, but when someone asks about tools, they
> want the IDEs and environments that let you get your work done.

Perhaps you should be having a go at the OP for not being precise, too.
>
> -G
> PS. I wasn't the only one who missed the 'red flags'. I'm just the guy
> who has to fix it. ;-)
> God I am starting to hate unicode.

Stop cock-waving. It's really tedious.

--
Cheers,
Obnoxio the Clown

http://obotheclown.blogspot.com

Unfortunately while I was growing up, my father stressed upon me the importance of nomenclature.
If you don't describe something explicitly and correctly, you can cause bad things to happen. An unintended slip of the tongue or use of a term thatmay have a slightly different meaning, you can cause someone to miss something and boom, a patient is hurt.

So to call C which is a programming language a 'tool' in the context of thequestion being asked, would be incorrect.
A c compiler is a tool that takes your C instruction set aka a program and generates either a bunch of error messages or an executable object.

I understood Art's point that there are many ways to build applications that utilize IDS. But the question dealt with programming and access environments like Toad. Anatol's ?sp? tool is probably the best example or DBAccess.

I dont' know if Eclipse supports ESQL/C (Or maybe rational does since both DB2 and IDS utilize the language), but Eclipse and NetBeans do support Python, Java, C/C++ So these IDEs could almost meet the initial poster's Needs.

Note: I didn't question Art's other products. Only calling these "tools". They're languages and APIs
Of course he didn't add Python, Jython, Groovy/Grails, or Ruby/Rails.(Although the database support (From IBM) of Ruby/Rails isn't all that great)
These are all languages and "frameworks" that could also be connected to IDS.

But hey! I'm not swinging anything around with Art. Just pointing out the importance of calling something right.

-G


> Date: Tue, 26 Aug 2008 13:47:10 +0100
> From: obnoxio-at-serendipita.com
> To: informix-list-at-iiug.org
> Subject: Re: informix developer tool
>
> Ian Michael Gumby wrote:
> > Sorry Art,
> > You may call them Tools of the trade.
> >
> > But nomenclature is important when you need to communicate an idea or
> > concept.
> Or: "since I don't have anything useful to say, I'll use arbitrary
> pedantry in a desperate attempt to win an argument." I get this from my
> 12-year-old daughter all the time.
>
> >
> > I'm now having to reverse a script I wrote for production because I
> > did what they said they wanted, not what they really wanted. And of
> > course, it was a rush job so there wasn't really time to get in to
> > their head and you had to trust that they knew what they were saying.....
> >
> > Yet I digress.
> >
> There's a first.
>
> > The point is that these are not tools but 'standard' APIs and Languages..
> >
> > Its great that you know them, but when someone asks about tools, they
> > want the IDEs and environments that let you get your work done.
>
> Perhaps you should be having a go at the OP for not being precise, too.
> >
> > -G
> > PS. I wasn't the only one who missed the 'red flags'. I'm just the guy
> > who has to fix it. ;-)
> > God I am starting to hate unicode.
>
> Stop cock-waving. It's really tedious.
>
> --
> Cheers,
> Obnoxio the Clown
>
> http://obotheclown.blogspot.com
>
>
>
>
>
> _______________________________________________
> Informix-list mailing list
> Informix-list-at-iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list

__________________________________________________ _______________
See what people are saying about Windows Live. Check out featured posts.
http://www.windowslive.com/connect?o...onnect2_082008

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-at-uwe.iiug.org> Subject: informix developer tool> Date: Mon,25 Aug 2008 16:04:59 +0000> To: informix-list-at-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-at-iiug.org> http://www.iiug.org/mailman/listinfo/informix-list

Thanks for adding Squirrel, Ian, but you mean SQuirreL SQL (also in Art's
list), which has an Informix plug-in (SQL by yours truly):

www.squirrelsql.org

Nothing like AGS Server Studio, but very useful for a freebie.

Regards,
Doug Lawry


"Ian Michael Gumby" wrote in message
news:5fc40b0a-1ab1-4114-8578-8183badb507f-at-p25g2000hsf.googlegroups.com...
> On Aug 25, 3:42 pm, "Art Kagel" wrote:
>> Develoment tools for Informix:
>>
>
>> Informix 4GL
>> Perl DBI
>> ESQL/C
>> ODBC
>> JDBC
>
> These are not tools...
>
> I-4GL - Language. (Unless you're talking about RDS)
> Perl-DBI - Perl Module
> ESQL/C - Language
> ODBC - API interface
> JDBC - API interface
>
> I agree that there are tools out there. SquirrelDB is another one.