Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Old Informix manual

    Posted 03/03/25 10:47 AM

    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
    ------------------------------


  • 2.  RE: Old Informix manual

    Posted 03/03/25 11:01 AM

    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

     






  • 3.  RE: Old Informix manual

    Posted 03/03/25 11:05 AM

    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

     






  • 4.  RE: Old Informix manual

    Posted 03/03/25 01:50 PM

    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
    ------------------------------



  • 5.  RE: Old Informix manual

    Posted 03/03/25 02:00 PM

    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
    ------------------------------

    Original Message


  • 6.  RE: Old Informix manual

    Posted 03/06/25 09:23 AM
    www.oninit.com/manuals   has some old documentation



    On 3/3/2025 12:59 PM, Art Kagel via IBM TechXchange Community wrote:
    010001955d610063-91cfa743-0fa3-4fe9-9508-6704d4c6e343-000000@email.amazonses.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 ... -posted to the "Informix" group



    Original Message


  • 7.  RE: Old Informix manual

    Posted 03/05/25 02:35 PM

    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
    ------------------------------



Related Content