Old Informix manual
Mister Snrub looked for an old Informix manual with text diagrams of SQL joins. Hal Maner suggested Informix Guide to SQL: Tutorial; Everett Mills also mentioned Ron Flannery's Informix Handbook; Art Kagel proposed the Performance Guide, now part of Administering Informix. Suman Suhag listed other candidates and Paul Watson pointed to old manuals on oninit.com. No confirmation.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Does anybody know the name of an old IBM Informix reference manual from the 80s/90s that had little text-based diagrams that illustrated SQL joins? It was a wonderful visual explainer as to exactly how outer and inner joins worked, and I have never seen joins explained so well since then. ------------------------------ Mister Snrub ------------------------------
You may be referring to: Informix Guide to SQL: Tutorial Indeed, this is * still * a great manual that I point every member of our team, especially new hires, to. Not only for Informix but to understand relational databases/SQL in general also. Hal Maner M Systems International, Inc. Phone: +1 (919) 493-6012 ext. 4009 hmaner@msystemsintl.com www.msystemsintl.com
If it was am official manual, it was probably the Informix Guide to SQL Syntax or Tutorial. I can't lay my hands on one right now. If not, I just looked at my copy of Ron Flannery's Informix Handbook. It has a good section on JOINs, with illustrations. --EEM
Are you thinking of the Informix Dunamic Server Performance Guide? It has diagrams like this: Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
FYI, what was the Performance Guide is still available, however, as of the v14.10 manuals and the online manuals, that content is part of the "Administering Informix" manual. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
Dear Sir, I think I may have found the manual "IBM Informix Guide to SQL: Tutorial and Reference" (1989) This manual is known for its clear explanations and visual diagrams, including text-based diagrams illustrating SQL joins. Another possibility is "IBM Informix SQL Reference" (1991) This manual also contains diagrams and explanations of SQL joins. ------------------------------ Suman Suhag Dev Bhoomi Uttarakhand University Business Development Intern GAO Tek Inc. Jhajjar, Haryana, India +91 8950196825 ------------------------------
www.oninit.com/manuals has some old documentation