How to use Informix Dynamic Server

Posted in 2008

Summary

A newcomer (an ASP.NET/SQL Server developer) installed the IDS 11.5 Developer Edition trial on Windows and asked how to use it, unsure whether IDS connects to an IBM server or to local SQL Server/Access data, where to create a database, and whether there's an equivalent of SQL Server Management Studio. After some snarky "read the manual" replies, helpful answers explained that IDS is itself the local database server, databases are created inside the instance, and tools such as dbaccess and the Open Admin Tool (OAT) can be used for creating tables and running queries, with links to the IBM Info Center documentation and a developerWorks tutorial.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Installation, Setup & Upgrades

BINDU SIVAJI — Wed, 11 Jun 2008 12:21:22 — source: IIUG Forums & Mailing Lists

I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.

↪ replying to BINDU SIVAJI

Obnoxio The Clown — Wed, 11 Jun 2008 12:26:59 — source: IIUG Forums & Mailing Lists

BINDU SIVAJI said: > I have installed trial version of "Informix IDS Dynamic Server Developer > Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i > am > new to informix. Can anyone explain how to use IDS in detail. Sure: read the fucking manual. -- Bye now, Obnoxio "There were a myriad of problems which conspired to corrupt your reason and rob you of your common sense. Fear got the best of you, and in your panic you turned to the Labour Party. They promised you order, they promised you peace, and all they demanded in return was your silent, obedient consent."

↪ replying to Obnoxio The Clown

Mark Tyrer — Wed, 11 Jun 2008 12:52:18 — source: IIUG Forums & Mailing Lists

Obnoxio!!! How could you do say something like that!!!! I'm totally disgusted.... Don't just come out and pass on trade secrets like that, its bad for job security. Next time, play with your victims a little, tell them something like .... I think what your looking for can be found at www.ibm.com Regards -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Obnoxio The Clown Sent: 11 June 2008 02:27 PM To: ids@iiug.org Subject: Re: How to use Informix Dynamic Server [12386] BINDU SIVAJI said: > I have installed trial version of "Informix IDS Dynamic Server > Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version > 1150TC1DE". But i am new to informix. Can anyone explain how to use > IDS in detail. Sure: read the fucking manual. -- Bye now, Obnoxio "There were a myriad of problems which conspired to corrupt your reason and rob you of your common sense. Fear got the best of you, and in your panic you turned to the Labour Party. They promised you order, they promised you peace, and all they demanded in return was your silent, obedient consent." **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Mark Tyrer

Obnoxio The Clown — Wed, 11 Jun 2008 12:57:02 — source: IIUG Forums & Mailing Lists

Mark Tyrer said: > Obnoxio!!! > > How could you do say something like that!!!! > > I'm totally disgusted.... > > Don't just come out and pass on trade secrets like that, its bad for job > security. > > Next time, play with your victims a little, tell them something like .... > > I think what your looking for can be found at www.ibm.com You're right. I like yours better. :o) -- Bye now, Obnoxio "There were a myriad of problems which conspired to corrupt your reason and rob you of your common sense. Fear got the best of you, and in your panic you turned to the Labour Party. They promised you order, they promised you peace, and all they demanded in return was your silent, obedient consent."

↪ replying to BINDU SIVAJI

Tilman Model-Bosch — Wed, 11 Jun 2008 13:25:41 — source: IIUG Forums & Mailing Lists

BINDU SIVAJI wrote: > I have installed trial version of "Informix IDS Dynamic Server Developer > Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am > new to informix. Can anyone explain how to use IDS in detail. Yes sure, as others already pointed out - it is a good idea to read the documentation. Start at : http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp

↪ replying to BINDU SIVAJI

Giri Raju — Wed, 11 Jun 2008 14:18:20 — source: IIUG Forums & Mailing Lists

Hi Bindu if you are specific what you want to know i can send some info. let me know your background (Professional) and goals. -Giri On Wed, Jun 11, 2008 at 8:21 AM, BINDU SIVAJI <sbindu_2007@hotmail.com> wrote: > I have installed trial version of "Informix IDS Dynamic Server Developer > Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i > am > new to informix. Can anyone explain how to use IDS in detail. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Giri Raju

↪ replying to Mark Tyrer

Miguel Carbone — Wed, 11 Jun 2008 21:26:48 — source: IIUG Forums & Mailing Lists

The informix documentation Cheetah 2 http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp Grato, Saluti, Best Regards, Mit Freundlichen Grüssen, Meilleures Salutation Miguel Carbone Miguel Carbone miguel@mcsoftware.com.br +55 11 9634 7103 +55 11 7832 7160 (Nextel ID: 55*84*23571) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Mark Tyrer Sent: quarta-feira, 11 de junho de 2008 09:52 To: ids@iiug.org Subject: RE: How to use Informix Dynamic Server [12388] Obnoxio!!! How could you do say something like that!!!! I'm totally disgusted.... Don't just come out and pass on trade secrets like that, its bad for job security. Next time, play with your victims a little, tell them something like .... I think what your looking for can be found at www.ibm.com Regards -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Obnoxio The Clown Sent: 11 June 2008 02:27 PM To: ids@iiug.org Subject: Re: How to use Informix Dynamic Server [12386] BINDU SIVAJI said: > I have installed trial version of "Informix IDS Dynamic Server > Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version > 1150TC1DE". But i am new to informix. Can anyone explain how to use > IDS in detail. Sure: read the fucking manual. -- Bye now, Obnoxio "There were a myriad of problems which conspired to corrupt your reason and rob you of your common sense. Fear got the best of you, and in your panic you turned to the Labour Party. They promised you order, they promised you peace, and all they demanded in return was your silent, obedient consent." **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Giri Raju

BINDU SIVAJI — Thu, 12 Jun 2008 04:33:40 — source: IIUG Forums & Mailing Lists

Hi Giri, I am basically a asp.net2.0(sqlserver2005) programmer. I have installed IDS but do not know how to use and i have got some doubts also i am listing below: 1. Whether IDS trial version connects to IBM server or it connects our local databases. If it connects to local machine means tell me whether it connects to sqlserver databases or access or which backend databases. 2. Using IBM Informix Dynamic Server 11.5 - Server instance manager i have created a connection, but i do not know where to create the database. 3. Can you understand my problem my direct question is, like sql server management studio in sqlserver2005 whether IBM IDS trial version provides any place for playing table creation, query running etc., Bye Bindu

↪ replying to BINDU SIVAJI

Obnoxio The Clown — Thu, 12 Jun 2008 07:43:27 — source: IIUG Forums & Mailing Lists

BINDU SIVAJI said: > Hi Giri, > > I am basically a asp.net2.0(sqlserver2005) programmer. I have installed > IDS > but do not know how to use and i have got some doubts also i am listing > below: > > 1. Whether IDS trial version connects to IBM server or it connects our > local > databases. If it connects to local machine means tell me whether it > connects > to sqlserver databases or access or which backend databases. I don't really understand the question. IDS does not connect to SQLServer unless you specifically jump through hoops to set it up. IDS is used instead of SQL Server. It is a backend database. > 2. Using IBM Informix Dynamic Server 11.5 - Server instance manager i have > created a connection, but i do not know where to create the database. In that instance. > 3. Can you understand my problem my direct question is, like sql server > management studio in sqlserver2005 whether IBM IDS trial version provides > any > place for playing table creation, query running etc., OAT here: https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg- informixfpd Support for OAT: either in this newsgroup or here: http://www.ibm.com/developerworks/forums/forum.jspa?forumID=1071 -- Bye now, Obnoxio "There were a myriad of problems which conspired to corrupt your reason and rob you of your common sense. Fear got the best of you, and in your panic you turned to the Labour Party. They promised you order, they promised you peace, and all they demanded in return was your silent, obedient consent."

↪ replying to BINDU SIVAJI

Art Kagel — Thu, 12 Jun 2008 11:46:03 — source: IIUG Forums & Mailing Lists

Bindu: See below: On Thu, Jun 12, 2008 at 12:33 AM, BINDU SIVAJI <sbindu_2007@hotmail.com> wrote: > Hi Giri, > > I am basically a asp.net2.0(sqlserver2005) programmer. I have installed IDS > but do not know how to use and i have got some doubts also i am listing > below: > > 1. Whether IDS trial version connects to IBM server or it connects our > local > databases. If it connects to local machine means tell me whether it > connects > to sqlserver databases or access or which backend databases. IDS is the local database server. > > > 2. Using IBM Informix Dynamic Server 11.5 - Server instance manager i have > created a connection, but i do not know where to create the database. Run the dbaccess tool. That's how you create databases, tables, etc. and can query the data, etc. > > > 3. Can you understand my problem my direct question is, like sql server > management studio in sqlserver2005 whether IBM IDS trial version provides > any > place for playing table creation, query running etc., Dbaccess, Open Admin Tool (OAT). -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@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.

↪ replying to BINDU SIVAJI

Jean Sagi — Thu, 19 Jun 2008 00:57:46 — source: IIUG Forums & Mailing Lists

Maybe you already got this link... but nevertheless here it go: http://www.ibm.com/developerworks/offers/lp/demos/summary/usingids1.html?S_TACT= 105AGX01&S_CMP=HP J. 2008/6/11 BINDU SIVAJI <sbindu_2007@hotmail.com>: > I have installed trial version of "Informix IDS Dynamic Server Developer > Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i > am > new to informix. Can anyone explain how to use IDS in detail. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Glossary

IDS (Informix Dynamic Server)