Acceptance platforms can vary by project. Traditional firsts have been SunOS 4.1.X, HP 9000/8xx, Sequent Dynix, IBM RS6000, NCR 3xxx. Solaris 2. will be replacing SunOS 4.1.X. 3B20 users, don't hold your breath. The Informix engine development team is located in Portland practically camped on Sequents doorstep. This is on purpose.
Originally from Jack Parker (email@example.com), and since updated by Kerry Sainsbury:
The enclosed is a list of Informix related books - I just compiled it from saved off messages from this group. The basic list is actually maintained by Walt Hultgren at Emory ( http://www.iiug.org/techinfo/booklist.html) - but I stuck in comments where I found them. And added a book or two.
My apologies in advance to the netters whose comments I stole from previous messages to stick after a book title.
Last Changed: Feb 1996
Entries are formatted with the following information:
Some entries may not be complete. If you know of any additions or changes that should be made to this list, please send them to firstname.lastname@example.org.
...it looked like a reference card, more than a tutorial book (Look at the size of the 4GL supplement, it's almost that size). I started flipping through the pages and discovered that about 150 of the 250 pages dealt with Database design and concepts. The remaining 100 pages contained about 10 pages worth of actual information; the remaining 90 pages were so poorly written that I had a hard time believing that the editor actually 'let it through'. Needless to say I gave the book back to them and asked them to put it back on the shelf for me. I think that the 4GL by example book is alot more worthwhile.
I was really disapointed to see that two-thirds of such an expensive book was dedicated to such introductory comments. I would expect this for a book written on Microsoft Access, or some software aimed at the masses, but I think that anyone who was at the level of learning 4GL would probably either have a good knowledge of the concepts of Tables, Columns and Indexes or would have a book in Database Theory.
I guess I sound like I'm wining, but I'm mostly wanted to warn people away from wasting their money. If this book hadn't been in a local store, I would have paid the money and ordered it.
- Daniel James - Database Administrator (email@example.com)
...I agree that it is a waste of the paper it uses. And the sheer number of blatant typographical errors in it is depressing. I'm no compiler, but a lot of the example code would clearly be rejected by the compiler. Ugh!
"...is dangerous. It has example 4GL code that can lead to corrupted data in a multi-user environment." - Anon
"Here's one that I've seen used in a college course, and which I give to programmers new to 4gl. It is *very* introductory, though, and if newbies look at any of our existing code they quickly find lots of stuff which this book does not cover."
- Clem Akins
"For more in-depth work I mostly like the Informix 4gl manuals, especially:"
These examples can provide some code and style guidelines for a shop of programmers with disparate styles."
- Clem Akins
"It contains a lot more than Ace reports and is worth having as a reference beside the Informix manuals, of course the author is known as a regular writer here on the net and may be happy to answer any questions arising from the text."
- Tom Hogarty
"I felt the stock Informix documentation was pretty opaque. I found "Using Informix-SQL, Second Edition" by Jonathan Leffler in a local computer superstore and have been very pleased with it. Much more approachable than the Informix manuals. I dont have any books to recommend if its not ISQL that you're interested in. For installation and management, I ended up taking the Informix training course, which did a good job of covering things."
- Joe Matuscak
- Malcolm Weallans, OnLine Database Consultancy
A special word of thanks to Joe Lumbley. I bought his book some time back, but never took the time to read it. A situation arose recently that I couldn't resolve with the usual manuals so I dragged out Joe's book. Not only did it clarify my problem. but it was actually FUN to read. His insights into user's expectations and mental processes brought many smiles and nods as I continued reading even after I had resolved my situation.
IMHO this book is a MUST for everyone who gets stuck being the DBA.
Disclaimer: I didn't make any money for saying the above.
- J. David Schronce
Gets consistantly good comments in comp.database.informix
"The following [preceeding] book is good, but only if you know some "SQL" - it serves as a reference book. It is based on the new SQL standard ISO 9075:1992(E) and is therefore quite relevant (i.e. not archaic)."
- Jayesh Thakrar
Books are available from Prentice Hall, Email: firstname.lastname@example.org More info is available from http://www.informix.com/
Start with www.iiug.org, the International Informix User Group's site (which includes links to everywhere else of interest), and then move on to Informix's own site at www.informix.com
You could also try examples.informix.com Kaye Bonney (byExample Web Mgr) described it as :-
This site is a online resource of technical information to help Informix developers master Informix and third-party products. It contains illustrated How To guides for connecting Informix to third-party products as well as detailed code examples, including annotations, that can be run interactively.
On 3rd Feb 1997 email@example.com (Todd Katz) wrote:-examples.informix.com/finderror is a Java-based utility that provides immediate access to meanings of all Informix error messages in an easy-to-use. form.
I think such a list is beyond the realms of a FAQ. If you're curious about such things consult with Informix-Link.
InformixLink TechInfo Center, the private, 24-hour on-line service, is designed to provide instant access to the most up-to-date information about Informix programs and services. InformixLink TechInfo Center is available via the World Wide Web, CD-ROM, and dial-up services. Available via subscription and only to INFORMIX-Assurance, INFORMIX-OpenLine, Regency Services, and INFORMIX-Enterprise customers, the InformixLink TechInfo Center is our primary, on-line mechanism for providing you with vital support information. TechInfo Center includes access to the folowing support features: Open a case Product Registration Alerts: up-to-the-minute information on our technology Porting reports Product defect reports Publications Product release information Events, including upcoming Informix-related activities and tradeshows With TechInfo Center, you are among the first to know about the latest offerings in training, specialized support offerings, product defects, and alerts. You will also receive unparalleled electronic access to mission critical support information, 24 hours a day, worldwide. World Wide Web Access TechInfo Center on the World Wide Web offers point-and-click graphical capabilities, extensive indexes, and links to related material - so you can navigate with little effort, through a vast store of information. You can: easily get additional information via hypernet cross references. You don't have to spend time hunting through various menus, lists, and documents in order to pull together a complete picture. We've already done the extensive linking for you. We also include a "What's New" section, so that you can easily locate the latest materials; request additional information through electronic forms. No need to telephone, no searches for envelopes and stamps, no hassles. Just a few keystrokes from you, and what you're looking for will be quickly on its way; send comments regarding specific pages. Your participation and feedback is very important to us. Our goal is to make the Web your one-stop shop for what you need - if there's a way we can improve it, we want to know. InformixLink TechInfo Center is accesible at the the following URL: http://www.informix.com/informix/services/introti.htm CD-ROM Access Sometimes network issues or network costs make Web access unrealistic. Some secure environments limit access to the Internet for data security reasons. To make InformixLink TechInfo Center access feasible under these circumstances, Customer Services has produced it on CD-ROM. CD-ROM subscribers receive all of the information contained in InformixLink TechInfo Center, including an easy to use graphical interface and extensive cross referencing. The year-long InformixLink CD-ROM subscription provides an essential resource for anyone who uses or supports Informix products. Extensive hypertext cross references allow users to locate the information quickly without hunting through endless menus, lists, and documents. The "What's New" section alerts users to the latest information. The CD-ROM contains all of the information available on the Web, and can be used to access other value-added services. Dial-Up Services Support Customers also have the option of using a dial-up service. Due to graphical and linking limitations, this option is not as versitile as access via the Web and CD-ROM. Dial-Up access also includes bulletin boards and forums, as well as electronic mail facilities. Registration Procedure To register, fill out the InformixLink Order Form at http://www.informix.com/informix/services/ilenroll or call 1 800 274 8184. Have the appropriate product serial number ready for account set up.
Yes!! At last. I-Connect, ESQL/C and SE have been ported. See the Informix on Linux FAQ at http://www.iiug.org/techinfo/linux/linux_faq.html
DISCLAIMER: Running SCO Informix under Linux is probabley a violation of your Software agreement.
From: firstname.lastname@example.org (F Korbel Natural Bros)
I am running Informix SE-4.xx, 4GL and debugger originally targeted for SCO UNIX, on linux. Here is a recap of how I did it:
P.S. Operations appear FASTER than on the native platform. Error 32766 means your sqlexec doesn't have the right permissions (I think).
From: email@example.com (Jeffrey Sturm)
It would be hard to use ESQL/C under Linux without an IBCS2 cross-development system. Since the ESQL/C libraries are not Linux-compatible, the Linux compiler/assembler/linker/etc. cannot be used. You also need a libc.a that is 100% compatible with SCO. I don't think the GNU libc meets this criteria without modification.
On 27th Dec 1997 firstname.lastname@example.org (David Williams) writes:-
I have got Informix-SQL 6.02.UC1 and Informix-SE 7.10.UC1 for SCO v126.96.36.199 working by:-
Loading the latest 2.0 kernel :-http://ftp.kernel.org/pub/Linux/kernel/v2.0/linux-2.0.33.gz Compile this with modules enabled and kerneld support.
Also you will needftp://ftp.cdrom.com/pub/linux/tsx-11/BETA/ibcs2/ibcs-2.0.970513.tar.gz
Unpack and follow the install instructions.ftp://ftp.cdrom.com/pub/linux/tsx-11/BETA/sco-libs-940731.tar.gz
Unpack into /shlibftp://ftp.cdrom.com/pub/linux/tsx-11/BETA/libnsl-960201.tar.gz
Unpack into /shlib
Copy the following files from a SCO machine into /usr/i486-sco/lib:-
/lib/crt1.o /lib/crtn.o /lib/libc.a /lib/libintl.a /lib/libm.a /lib/libos.a /lib/libprot.a /lib/libx.a /usr/lib/libcrypt_i.a /usr/lib/libcurses.a /usr/lib/libgen.a /usr/lib/libnsl_s.a /usr/lib/libsocket.a
NOTE: I have not tried shared libraries yet, if you want to you may also need to take across /shlib at this point(??)
Finally you need to make some adjustments to the c4gl script!
Since this is copyright I can't give out the new version.However, (I hope) I can say that you need to:-
email@example.com (Marco Greco) has the only Web site with notes how to run Informix on Linux:-http://www.ctonline.it/~marcog/ifmxlinux.htm
"The Butler Group" have about reviews and opinions about practically every database product and development tool on the planet. Take a look at their Web page at: http://www.butlergroup.co.uk
On 13th August 1999 mosserp@WellsFargo.COM (mosserp) wrote:-
And also worth mentioning is the availability of Informix Enterprise Support, under which Informix, for a slight fee, of course ;-), will place "an advanced support level / source code engineer" (our ESE is patch-certified) ON-SITE to assist with any questions / problems / planning / emergencies / etc. This means you have a fully-qualified, knowledgeable engineer to work on YOUR open cases -- and he/she is just down the hall from you!! The price is probably a little steep for small sites, but, if you are using Informix heavily with lots of boxes / instances, and most especially if those Informix databases are critical to the business, then it is well worth the price.